Hi!

What do you want to do if sheet1 C10 does not = AVAIL ?

Enter this formula in Sheet2 D8:

=IF(Sheet1!C10="avail","off","not defined")

Biff

"JOOPEE" wrote in message
...
HOW CAN I ON SHEET-1 CELL C-10=AVAIL, THEN ON SHEET-2 CELL D-8=OFF