| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
IF COMMAND WITH TEXT
HOW CAN I ON SHEET-1 CELL C-10=AVAIL, THEN ON SHEET-2 CELL D-8=OFF
|
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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","") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
