Remember Me?

#1
July 14th 05, 06:43 PM
 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

#2
July 14th 05, 07:16 PM
 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

#3
July 14th 05, 08:40 PM
 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

 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.