Remember Me?

 Templee1 Posts: n/a 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.

--
Templee1
------------------------------------------------------------------------
Templee1's Profile: http://www.excelforum.com/member.php...o&userid=25083

 Dave R. Posts: n/a 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.

--
Templee1
------------------------------------------------------------------------
Templee1's Profile:

http://www.excelforum.com/member.php...o&userid=25083

 Morrigan Posts: n/a =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.

--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post thejudge Excel Worksheet Functions 2 June 9th 05 04:55 PM sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM Ad Buijs Excel Discussion (Misc queries) 3 April 20th 05 09:41 PM Bonnie Excel Worksheet Functions 2 April 14th 05 09:28 PM merlin68 Excel Worksheet Functions 4 April 14th 05 03:24 AM

All times are GMT +1. The time now is 11:47 AM. Copyright ©2004-2021 ExcelBanter.