logic in openoffice calc

edgjerp · 05-14-2006, 06:12 AM

anyone know how to emulate the "else if" function in OOo?

I want it to check another "if statement" if the first one comes out false.

pseudocode: if cellvalue=4.5, <action1>, elseif cell>4,5 <action2>, else <falseaction>.

meng · 05-14-2006, 07:56 AM

Nested IF functions:
IF(A1=4.5;<value>;IF(A1>4,5;<value2>;<value3>))

edgjerp · 05-14-2006, 08:13 AM

it works now. I tried this before, but got #NAME? when I tried it. gues I had some parentheses wrong.