Hi,

I'm facing a problem in getting the desired result in a nested IF statement. My problem is summarized as under:

1) F27>=40% K27*4500
2) F27>=30% K27*4000
3) D44=C44 & D45=C45

I have arrived at the formula =IF(AND($D$44=$C$44,$D$45=$C$45),IF(F27>=40%,K27*4500,IF(F27>=30%,K27*4000,0))) but getting the result as False.

Kindly help to get the desired result.