IF Formula with 2 condtions in it...

[jur78]

Hello,

I am a bit of an inexperienced user so I hope someone can maybe help me with the following:

I am not sure if it is possible but I would like to create an conditional formula like the following:

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

Meaning, I want the cel value to be AB4 +(0.25*E4) if cel D4 is bigger than 40, but at the same time, if cel D4 is bigger than 60, the outcome has to be AB4 +(0.50*E4). If both conditions are not met, I want the cel to be just AB4.

So actually it is three conditions that I want the formula to check. Now, the problem is that when I use the above mentioned formula, it will only check the first part of formula. So in this case, if D4>40, then it will come up with AB4 +(0.25*E4), if not, it just gives me AB4. Conclusion, it skips my second condition. I have tried with values above 60 but the formula just doesn't recognise it and will not do AB4+(0.5*E4) in case D4>60...

Does anyone have a clue which formula I can use, or what I should change?

Thanks for your help!
Jurryt

[oldchippy]

Try this,

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

[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*

[jur78]

Try this,

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

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!!!

[jur78]

Try this,

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

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!!!

[jur78]

Try this,

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

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!!!