how do I write an "if then" statement in Excel. eg. If L47 = 0 the

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up a quick way to see if a certain set of data is within the
limits set.

I think it was called an "if then" statement.

I want to display the word "OK" in cell M47 if L47 is equal to zero. If it
is less than zero I want it to display "fix" in cell M47, and if it is more
than zero I want it to display "add" in cell M47

I know this formula exsists but I can't find it in my Excel training book.
 
=IF(M47=0,"OK",IF(M47<0,"fix","add"))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to set up a quick way to see if a certain set of data is within the
| limits set.
|
| I think it was called an "if then" statement.
|
| I want to display the word "OK" in cell M47 if L47 is equal to zero. If it
| is less than zero I want it to display "fix" in cell M47, and if it is more
| than zero I want it to display "add" in cell M47
|
| I know this formula exsists but I can't find it in my Excel training book.
 
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

Subtracting cell contents - I can't believe it's not working! 2
Combining IF Statement and Vlookup 0
need help with syntax of if statement 3
I want to create an IF statement that leaves a cell blank if.... 6
NumberFormat instead of an IF 2
IF STATEMENT, GREATER THEN 0 ADD ANOTHER CELLS AMOUNT 2
Formula - If Statement with blank 3
If then statement 4

Back
Top