Excel 2007 IF/AND formulas Closed

Question

Hello,
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.

SueBeeHoney · Answer

Whoops, forgot one vital piece of information.  If A1=" ", then do nothing.

huko · Answer

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.

Excel 2007 IF/AND formulas

2 responses

Similar discussions

Subscribe To Our Newsletter!