FALSE in IF condition

[yaelcohen]

Hello

I have in the attached file a formula with if condition. The formula says that if the conditions do not exist then write "3". I can not understand why it is written False

Please help

Thanks

 

[NARAYANK991]

Hi ,

The formula you have entered is :

=IF(B5>0,IF(A5<B5/3,1,IF(AND(A5>B5/3,A5<B5*2/3),2)),3)

The values in A5 and B5 are :

A5 : 15%

B5 : 10%

If we go through the evaluation of the above formula ,

1. B5 > 0 is satisfied

2. A5 < B5/3 is not satisfied

which means we are now left with the following condition to be checked :

IF(AND(A5>B5/3,A5<B5*2/3),2)

If we evaluate this formula ,

3. A5 > B5/3 is satisfied

4. A5 < B5*2/3 is not satisfied

Hence the AND of the above two tests returns FALSE.

Since the output when the condition is FALSE is not specified ( the output when the condition is TRUE is specified as 2 ) , Excel returns FALSE.

Narayan

 

[chirayu]

Because your formula was incorrect. Check below

=IF(A5<(B5/3),1,IF(AND(A5>(B5/3),A5<((B5*2)/2)),2,3))

 

[yaelcohen]

Thanks a lot!