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.
Bookmarks