mardi 7 juillet 2015

If statement in excel?

I found that excel has an if feature that is = IF(booleanExpression, trueValue, falseValue)

I am trying to use it but i think there is something wrong with my boolean statement.

I have: =IF ( ( ((.8*P20)>(1.35*H20)) AND ( (.8*P20)<(2*H20))), (.8*P20), (1.35*H20))

I'm assuming my problem is with the AND part. Is there a way i can check two conditions here?

Aucun commentaire:

Enregistrer un commentaire