SOLVED

Seeking for a Formula

Copper Contributor

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.

2 Replies
best response confirmed by sai9497 (Copper Contributor)
Solution

@sai9497 

Let'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

@Hans Vogelaar Thank you for you response. It worked absolutely.

1 best response

Accepted Solutions
best response confirmed by sai9497 (Copper Contributor)
Solution

@sai9497 

Let'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

View solution in original post