Search : in
By :

Excel 2007 IF/AND formulas

Last answer on Sep 30, 2009 5:58:47 pm BST SueBeeHoney, on Sep 30, 2009 5:33:17 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP Internet Explorer 7.0

Best answers for « Excel 2007 IF/AND formulas » in :
[Excel 2003] - IF Function using Dates &amp; Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Excel - IF formulas for Printing and Calculation ShowExcel - IF formulas for Printing and Calculation Issue Solution Note Issue I am trying to get Excel IF formulas to print a text and calculation based on true/false. Such as, if I have some dates, and I don’t need to send a notice to a...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

 SueBeeHoney, on Sep 30, 2009 5:58:47 pm BST
  • +1

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

   
Reply to SueBeeHoney
Ask your question Reply
They need your help