Excel 2007 IF/AND formulas
Closed
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.
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.
Related:
- Excel 2007 IF/AND formulas
- Save as pdf office 2007 - Download - Other
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel mod apk for pc - Download - Spreadsheets