HOW CAN I ON SHEET-1 CELL C-10=AVAIL, THEN ON SHEET-2 CELL D-8=OFF
B Biff Nov 10, 2005 #2 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
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
H Harlan Grove Nov 10, 2005 #3 JOOPEE wrote... HOW CAN I ON SHEET-1 CELL C-10=AVAIL, THEN ON SHEET-2 CELL D-8=OFF Click to expand... Turn off your Caps Lock. Use the following formula in Sheet2 cell D8. Sheet2!D8: =IF(Sheet1!C10="AVAIL","OFF","")
JOOPEE wrote... HOW CAN I ON SHEET-1 CELL C-10=AVAIL, THEN ON SHEET-2 CELL D-8=OFF Click to expand... Turn off your Caps Lock. Use the following formula in Sheet2 cell D8. Sheet2!D8: =IF(Sheet1!C10="AVAIL","OFF","")
