MrExcel Publishing
Your One Stop for Excel Tips & Solutions

If Statement

Posted by Brittany on August 01, 2001 3:25 AM

Column a = x
Column B = x

Dolumn D = I would Like P placed in column D if x is in Column A and or B in placed in Column D if x in Column B-----There will never be an X in Col A and Col B at the same time....

If it would be easier to program, I could Change Col A to a P and Column B to a B in place of the X's

Thank you!


Posted by Damien on August 01, 2001 3:36 AM

Put this formula in cell d1
=IF(A2="X","P",IF(B2="X","B","No XXX's"))

drag formula down to what ever celll you want

Posted by Brittany on August 01, 2001 11:30 PM


Thank you!!!

It worked perfectly....