Forum Discussion

SAM_SUNG's avatar
SAM_SUNG
Copper Contributor
Dec 27, 2021

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 cell value is greater than 0.25 but less than or equals to 0.5, the result must be 0.5
if the cell value is greater than 0.5, the result must be 1
I am trying but not getting the exact answer
Please guide me with complete condition to be written in Excel for getting the desired result.
Thank You

2 Replies

Resources