mardi 26 avril 2016

Excel Programming - If Statement

I have coded on C# before and know all of the basics to do with loops and statements. I have been trying to make a simple IF statement on excel but a very unhelpful error comes up every time I try and run it. I was wondering if anyone would be able to point out what I'm doing wrong here -

I'm just trying to output a "Yes" If cell h14 is greater than 250 OR less than 250 AND cell I14 is greater than 0.15 OR less than -0.15 else output "No"

This is what I came up with but it doesn't seem to work: IF((H14>=250 OR H14<=-250) AND (I14 >= 0.15 OR I14 <= -0.15),"Yes", "No")

Many Thanks

Aucun commentaire:

Enregistrer un commentaire