jeudi 14 mai 2015

Excel query with regards to IF statements

I have the following formula in an excel sheet that generally works perfectly:

=IF(F5>=30.01,(39+(C5*0.08)),IF(AND(F5>=20.01,F5<=30),(39+(C5*0.07)),IF(AND(F5>=10.01,F5<=20),(39+(C5*0.06)),IF(AND(F5>=5.01,F5<=10),(39+(C5*0.05)),IF(AND(F5>=2.01,F5<=5),(39+(C5*0.04)),IF(AND(F5>=1.01,F5<=2),(39+(C5*0.03)),IF(AND(F5>=0.25,F5<=1),(39+(C5*0.02)),IF(AND(F5>=0,F5<=0.245),(0.03*C5*F5)))))))))

I was just wondering if anyone could tell me how to edit this so that if the result of the formula is less than '43', that the number inputted into the cell should be 43?

I have been trying to edit this accordingly for a while and I'm not sure what I need to do to make that happen.

The rest of the formula works exactly as I need it to, I just need the sheet not to produce a result that is less than 43.

Thank you so much for all your assistance!

Aucun commentaire:

Enregistrer un commentaire