Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 14th 05, 06:43 PM
Templee1
 
Posts: n/a
Default 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


  #2   Report Post  
Old July 14th 05, 07:16 PM
Dave R.
 
Posts: n/a
Default

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



  #3   Report Post  
Old July 14th 05, 08:40 PM
Morrigan
 
Posts: n/a
Default


=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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formula thejudge Excel Worksheet Functions 2 June 9th 05 04:55 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
how to create a multiple conditional formula Ad Buijs Excel Discussion (Misc queries) 3 April 20th 05 09:41 PM
can I move data from workbook A to B using a conditional formula Bonnie Excel Worksheet Functions 2 April 14th 05 09:28 PM
How to combine conditional format with formula ? merlin68 Excel Worksheet Functions 4 April 14th 05 03:24 AM


All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017