If Function

T

Terri

I need help with an If Function, I need it to tell me if I have a net Income
or Net Loss plus subtract a cell from another on then add the cell with if
statement in it to another one Example:If=H25>0Net income" or Net loss then
subtract h24 from I24 Can anyone please help
 
D

Dave O

Sounds like this would do the trick:
=IF(H25>0,"Net Income","Net Loss "&TEXT(I24-H24,"$0.00"))

Is that close?
 
Top