Here is a quick fix:
Replace ==> =IF(sheet1.A1="A";"ADULT";"CHILD")
With ==> =IF(OR(Sheet1.A1="a";Sheet1.A1="A");"ADULT";"CHILD")
I believe the functions are case sensitive, though they are not listed
as such in the help section. I was able to remedy the issue with the
second function though.
Michael
Arnold Huzen wrote:
I've got the same as Ain. Function is functioning properly unless I
put a small a in cell A1 instead of the capital A.
Arnold Huzen
Ain Vagula schreef:
steve wrote:
I'm on sheet3 and I've got:
=IF(sheet1.A1="A";"ADULT";"CHILD")
It always puts CHILD no matter what.
SuSE 10.1 with OOO from the SuSE DVD.
Any ideas?
Cheers, Steve.
Works here with no problems. With SLED 10, OO.o from community.
(btw, I can replicate this only, when Tools- Options - OO.o Calc -
Calculate - Case sensitive is marked and I write lowercase "a" into
A1 in
Sheet1.)
ain
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
