A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

iserror and ifs nested formulas



 
 
Thread Tools Display Modes
  #1  
Old June 4th, 2010, 06:05 PM posted to microsoft.public.excel.worksheet.functions
Vicki
external usenet poster
 
Posts: 145
Default iserror and ifs nested formulas

Please help!

I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.

I am using the below formula.

=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)ABS(20),((C30-$G30)/$G30)," "))

Thanks

  #2  
Old June 4th, 2010, 07:55 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default iserror and ifs nested formulas

Try

=IF(ISERROR((C30-$G30)/$G30),"-",IF(ABS(C30-$G30)/$G300.2,(C30-$G30)/$G30,"
"))

--

HTH

Bob

"Vicki" wrote in message
...
Please help!

I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.

I am using the below formula.

=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)ABS(20),((C30-$G30)/$G30),"
"))

Thanks



  #3  
Old June 4th, 2010, 08:06 PM posted to microsoft.public.excel.worksheet.functions
David Biddulph
external usenet poster
 
Posts: 8,714
Default iserror and ifs nested formulas


=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)20%,((C30-$G30)/$G30),"
"))

Your formula had greater than, but not less than.
20 is different from 20% (by a factor of 100).
You don't need the ABS function.
--
David Biddulph


"Vicki" wrote in message
...
Please help!

I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.

I am using the below formula.

=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)ABS(20),((C30-$G30)/$G30),"
"))

Thanks


  #4  
Old June 4th, 2010, 08:34 PM posted to microsoft.public.excel.worksheet.functions
Steve
external usenet poster
 
Posts: 2,662
Default iserror and ifs nested formulas

What numbers are likely to be in cells C30 and G30
What should it be 20% of
Why use ABS
What errors do you anticipate

Regards
Steve

"Vicki" wrote:

Please help!

I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.

I am using the below formula.

=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)ABS(20),((C30-$G30)/$G30)," "))

Thanks

  #5  
Old June 4th, 2010, 09:34 PM posted to microsoft.public.excel.worksheet.functions
Vicki
external usenet poster
 
Posts: 145
Default iserror and ifs nested formulas

Bob,

Thank you so much for your input. This formula worked GREAT!

"Bob Phillips" wrote:

Try

=IF(ISERROR((C30-$G30)/$G30),"-",IF(ABS(C30-$G30)/$G300.2,(C30-$G30)/$G30,"
"))

--

HTH

Bob

"Vicki" wrote in message
...
Please help!

I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.

I am using the below formula.

=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)ABS(20),((C30-$G30)/$G30),"
"))

Thanks



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.