Using a Formula in a Conditional Statement?
 

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.


--
Templee1
------------------------------------------------------------------------
Templee1's Profile: http://www.excelforum.com/member.php...o&userid=25083
View this thread: http://www.excelforum.com/showthread...hreadid=387263

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(B50,0,IF(B5<0,ABS(B5)))



"Templee1" wrote in
message ...

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.


--
Templee1
------------------------------------------------------------------------
Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
View this thread: http://www.excelforum.com/showthread...hreadid=387263

=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