Discussion Re: NESTED IF (Simple Question) in Excel
https://techcommunity.microsoft.com/t5/excel/nested-if-simple-question/m-p/3046184#M127279
<P><LI-USER uid="1259937"></LI-USER> </P><P>Let's say the value you want to check is in A1, then the formula could be:</P><P> </P><LI-CODE lang="applescript">=LOOKUP(A1,{0,0.25,0.5},{0,0.5,1})</LI-CODE><P> </P><P> </P>Mon, 27 Dec 2021 09:06:39 GMTRiny_van_Eekelen2021-12-27T09:06:39ZNESTED IF (Simple Question)
https://techcommunity.microsoft.com/t5/excel/nested-if-simple-question/m-p/3046180#M127277
<P><SPAN>Hi,</SPAN><BR /><SPAN>I just wanna ask a simple question. A cell containing a value = 0.3</SPAN><BR /><SPAN>Now i want to use NESTED IF for the following criteria:</SPAN><BR /><SPAN>if the cell value ranges b/w 0 to 0.25, the result must be 0</SPAN><BR /><SPAN>if the cell value is greater than 0.25 but less than or equals to 0.5, the result must be 0.5</SPAN><BR /><SPAN>if the cell value is greater than 0.5, the result must be 1</SPAN><BR /><SPAN>I am trying but not getting the exact answer</SPAN><BR /><SPAN>Please guide me with complete condition to be written in Excel for getting the desired result.</SPAN><BR /><SPAN>Thank You</SPAN></P>Mon, 27 Dec 2021 08:47:44 GMThttps://techcommunity.microsoft.com/t5/excel/nested-if-simple-question/m-p/3046180#M127277SAM_SUNG2021-12-27T08:47:44ZRe: NESTED IF (Simple Question)
https://techcommunity.microsoft.com/t5/excel/nested-if-simple-question/m-p/3046184#M127279
<P><LI-USER uid="1259937"></LI-USER> </P><P>Let's say the value you want to check is in A1, then the formula could be:</P><P> </P><LI-CODE lang="applescript">=LOOKUP(A1,{0,0.25,0.5},{0,0.5,1})</LI-CODE><P> </P><P> </P>Mon, 27 Dec 2021 09:06:39 GMThttps://techcommunity.microsoft.com/t5/excel/nested-if-simple-question/m-p/3046184#M127279Riny_van_Eekelen2021-12-27T09:06:39ZRe: NESTED IF (Simple Question)
https://techcommunity.microsoft.com/t5/excel/nested-if-simple-question/m-p/3046195#M127284
0.3 is in cell A1<BR />=IF(A1<=0.25,"0",IF(A1<=0.5,"0.5",IF(A1>0.5,"1")))Mon, 27 Dec 2021 09:26:52 GMThttps://techcommunity.microsoft.com/t5/excel/nested-if-simple-question/m-p/3046195#M127284Sumit_05052021-12-27T09:26:52Z