profit/loss

D

Dee

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

Norman Harker

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
[email protected]
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!!!!
 
Top