if then formula help

[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.

 

[Pete_UK]

Put this in D36 of the second sheet (GC):

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

Hope this helps.

Pete