If Function
 

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=H250Net income" or Net loss then
subtract h24 from I24 Can anyone please help

--
Terri

If Function
 

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

Is that close?

If Function
 

=if(H25Net income,I24-H24,[ELSE YOUR OTHER CONDITION])

Dave
--
Brevity is the soul of wit.


"Terri" wrote:

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=H250Net income" or Net loss then
subtract h24 from I24 Can anyone please help

--
Terri