Ubuntu

IF functions in Open Office spreadsheet won't work

Asked by Lia

Wwhenever I try to use an IF function in the OO spreadsheet, for example: =IF(N7>0;P7;"0") --in other words, if N7 is greater than 0, display P7, otherwise display 0 -- it comes up with a 508 error message, which means "pair missing" i.e. missing bracket. But both brackets are there. Why is this happening? have I missed something? I checked OO Help and as far as I can tell I'm using the IF function correctly.

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Solved by:
fluxy
Solved:
Last query:
Last reply:
Revision history for this message
Best fluxy (myusufs) said : 		#1

It works if you use commas instead of semi-colons, i.e. instead of:
=IF(N7>0;P7;"0")
try:
=IF(N7>0,P7,"0")

I'm a bit puzzled myself because I always thought, unlike MS Excel, OO.o Calc used ";", but it works.
(Try using the formula wizard denoted by f(x) icon on the toolbar, in case you get errors with formulae.)

Revision history for this message
Lia (lia-openaccess) said : 		#2

It works! thank you so much.

Revision history for this message
Lia (lia-openaccess) said : 		#3

Thanks fluxy, that solved my question.