Excel 2007 IF/AND formulas

SueBeeHoney - Sep 30, 2009 at 12:33 PM
 huko - Sep 20, 2010 at 02:51 PM
I am struggling to put together an IF/AND statement and keeping coming up with errors. I am fairly Excel savvy, but this one is kicking my butt! Here's the scenario:

I want a formula that says
If the value in A1="X" and b1>b2 produce a "Yes"
If the value in A1="X" and b1<b2 produce a "No"
If the value in A1="X" and b1=b2 produce an "Even"

If shouldn't be that difficult. Maybe it's the lack of sleep that has my brain befuddled.

Thanks for any help you can lend.

2 responses

Whoops, forgot one vital piece of information. If A1=" ", then do nothing.
To use 'and' formula all thre condition must be thrue to produce 'Yes' otherwise will produce 'No' so you can use only if/and function try if/or function.