LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   logic in openoffice calc (https://www.linuxquestions.org/questions/linux-software-2/logic-in-openoffice-calc-444633/)

edgjerp 05-14-2006 06:12 AM
logic in openoffice calc
 
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.


All times are GMT -5. The time now is 06:57 AM.