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.

[Morrigan]

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

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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>

[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)))



"Templee1" <[email protected]> wrote in
message news:[email protected]...
>
> 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.
>
>
> --
> Templee1
> ------------------------------------------------------------------------
> Templee1's Profile:
http://www.excelforum.com/member.php...o&userid=25083
> View this thread: http://www.excelforum.com/showthread...hreadid=387263
>