Dec 28 2020 02:50 PM
Hello guys,
I need a help in finding a formula. Here are my conditions:
1. I need to get 3 Results 0, 0.5 and 1.
2. My condition is if the value of the cell is not given then the output should be 0,
If my cell value is 0<X<=4 then my result should be 0.5,
If my cell value is X>4 then result should be 1.
3. Is it possible to give the 3 conditions.
I would be glad with the answers. Thanks in advance.
Dec 28 2020 02:57 PM - edited Dec 28 2020 03:08 PM
SolutionLet's say the value is in cell A2.
In another cell, for example B2, enter the formula
=IF(A2>4,1,IF(A2>0,0.5,0))
or
=((A2>0)+(A2>4))/2
Dec 28 2020 03:05 PM
@Hans Vogelaar Thank you for you response. It worked absolutely.
Dec 28 2020 02:57 PM - edited Dec 28 2020 03:08 PM
SolutionLet's say the value is in cell A2.
In another cell, for example B2, enter the formula
=IF(A2>4,1,IF(A2>0,0.5,0))
or
=((A2>0)+(A2>4))/2