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

D

dxrok

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.
 
N

Niek Otten

=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.
 
Top