Bashar Maree wrote:
Hi all,
What is the way to write an exclusive -or function in Calc. I know that in
Exel the form is '=IF(A5=C5,0,1)' but when I write that in Calc and press
enter I get a '#NAME?' string within the cell. Thanks in advance
--
Bashar Maree
Most Excel functions map directly to Calc functions but the syntax is
slightly different. Separate arguments to functions with a semi-colon
(;) instead of a comma. So your function would be '=IF(A5=C5;0;1).
--
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
