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