Using a Formula in a Conditional Statement?

[Templee1]

Is there a way to utilize a formula within a conditional statement? I
am an undergraduate student doing research in hydrology and am
constructing a water balance. What I need is the following:
=IF(B5>0,"0",IF(B5<0,"=abs(B5)")), where the "abs(B5)" would be the
absolute value of the cell B5 inserted into the spreadsheet.

Thank you for your help.

 

[Dave R.]

You've almost got it, but you need to remove the = from before the ABS, and
take the quotes out too. Quotes are for text..

=IF(B5>0,0,IF(B5<0,ABS(B5)))

 

[Morrigan]

=IF(B5>0,0,ABS(B5))

Is there a way to utilize a formula within a conditional statement?
am an undergraduate student doing research in hydrology and a
constructing a water balance. What I need is the following:
=IF(B5>0,"0",IF(B5<0,"=abs(B5)")), where the "abs(B5)" would be th
absolute value of the cell B5 inserted into the spreadsheet.

Thank you for your help