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!
Brittany...
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
Damien:
Thank you!!!
It worked perfectly....
Brittany
``````````````````````````````````````````````````
