IF COMMAND WITH TEXT

  • Thread starter Thread starter Guest
  • Start date Start date
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...
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","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Update cell value based on name and specific date 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
IF function possible? 4
Excel VBA to move cells to sheet2 based on selection in sheet1 0
product code a value 0
drag across multiple data sets 4
Problem in If function 7

Back
Top