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.