Forum Discussion
NESTED IF (Simple Question)
Hi, I just wanna ask a simple question. A cell containing a value = 0.3 Now i want to use NESTED IF for the following criteria: if the cell value ranges b/w 0 to 0.25, the result must be 0 if the...
Let's say the value you want to check is in A1, then the formula could be:
=LOOKUP(A1,{0,0.25,0.5},{0,0.5,1})