if then formula help

  • Thread starter Thread starter SHARON
  • Start date Start date
S

SHARON

i have 2 worksheets in one file....Below i will explain what i want to
happen, seems simple, but i can't get it to work....Thanks for any help.

In worksheet 1 titled PPELC - If cell B25 has an X in it, then on worksheet
2 titled GC, i want cell D36 to say YES, and if B25 is blank, then i want
cell D36 to say no.

Hope this makes sense.
 
Put this in D36 of the second sheet (GC):

=IF(PPELC!B25="X","Yes",IF(PPELC!B25="","no",""))

Hope this helps.

Pete
 
Back
Top