profit/loss

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

Guest

I have to add a row to the bottom of my worksheet which tests the amount of profit made in each relevant column and returns the word profit if this figure is greater than zero and loss if it is equal or less than zero (this is for a mock exam and it says to use an IF statement - please help!!!!
 
Hi Dee!

=IF(A1>0,"Profit","Loss")

Because the condition is A1>0 the false return will cover <=0

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Dee said:
I have to add a row to the bottom of my worksheet which tests the
Click to expand...
amount of profit made in each relevant column and returns the word
profit if this figure is greater than zero and loss if it is equal or
less than zero (this is for a mock exam and it says to use an IF
statement - please help!!!!
 
Back
Top