Alternative to If Function on Open Office Calc

Hi Guys,

I been researching but fail to find an alternative of this function.
The reason I require this alternative is because it is the best way I can relate to what I want,

My issue is I have more than 2 value and IF function only allows two value to be entered.

With two value : example:
=IF(E13>1;"FALSE";"TRUE")

But now I have more than 2 values in which,
=IF
E13>1 then F13 = 2
E13>3 then F13 = 3
E13>5 then F13 = 4
E13>7 then F13 = 5

Would greatly appreciate if anyone can assist me on this.

Originally Posted by Tony Valko

Try this...

=IF(E13>7;5;IF(E13>5;4;IF(E13>3;3;IF(E13>1;2;""))))

Thanks, it sure worked!
I tried it before but didn't work, Thanks to you I figured out the issue, the number has to be descending it seems !!
Cant believe i spent like 4 hours on this
You are a life saver