ExcelBanter - IF COMMAND WITH TEXT

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF COMMAND WITH TEXT (https://www.excelbanter.com/excel-worksheet-functions/54895-if-command-text.html)

JOOPEE

IF COMMAND WITH TEXT

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

Biff

IF COMMAND WITH TEXT

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

Harlan Grove

IF COMMAND WITH TEXT

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","")

All times are GMT +1. The time now is 12:07 PM.