"IF,THEN FUNCTION" Question
Posted by Rich wong on December 03, 2001 3:47 PM
To anybody out there....
I have a question concerning the usage of "If,Then" functions in Excel. I understand how to use the basic form of this function. However, if I want two conditions (instead of one), how would I write it?
More specifically, I have two cells, B3 and C3. I want it so the difference of C3-B3 will yield "YES", if the number is greater than 5, and "NO" for all other answers. HOWEVER, I ALSO, want the condition "YES" tied also to the value of B3 ALSO being greater than 50.
Confused? Well, without the second condition (greater than 50), I would simply have:
But now, I want to include the second condition of B3 also being greater than 50. THIS IS WHERE I'M STUCK.
Any help would be appreciated.