if then formula help
 

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.
--
Thanks,
Sharon

if then formula help
 

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

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

Hope this helps.

Pete

"SHARON" wrote in message
...
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.
--
Thanks,
Sharon