IF Formula with 2 condtions in it...

Originally Posted by oldchippy

Try this,

=IF(D4>60,$AB$4+(0.5*E4),IF(D4>40,$AB$4+(0.25*E4),$AB$4))

Originally Posted by molnar

Hmmm.....What if you try something like this:

=IF(AND(D4>40,D4<59),$AB4+(0.25*E4),IF(D4>60,$AB4+ (0.5*E4),$A B4))

Hope that helped.

*Molnar*

Brilliant, both worked just fine! Thanks Oldchippy and Molnar, thanks a lot for your help!!!