Forum Discussion
SAM_SUNG
Dec 27, 2021Copper Contributor
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...
Sumit_Bhokare
Dec 27, 2021Brass Contributor
0.3 is in cell A1
=IF(A1<=0.25,"0",IF(A1<=0.5,"0.5",IF(A1>0.5,"1")))
=IF(A1<=0.25,"0",IF(A1<=0.5,"0.5",IF(A1>0.5,"1")))