IF COMMAND WITH TEXT

[JOOPEE]

HOW CAN I ON SHEET-1 CELL C-10=AVAIL, THEN ON SHEET-2 CELL D-8=OFF

[Biff]

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" <[email protected]> wrote in message
news:[email protected]...
> HOW CAN I ON SHEET-1 CELL C-10=AVAIL, THEN ON SHEET-2 CELL D-8=OFF

[Harlan Grove]

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

Turn off your Caps Lock. Use the following formula in Sheet2 cell D8.

Sheet2!D8:
=IF(Sheet1!C10="AVAIL","OFF","")