=IF(B50,0,ABS(B5))
Templee1 Wrote:
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(B50,"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.
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=387263