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