# IF in IFERROR, need the result to be 0% if there is an error or the answer is 100%

1. ## IF in IFERROR, need the result to be 0% if there is an error or the answer is 100%

Hi everyone!

I am calculating percentage change with formula: =(IFERROR((D6-C6)/C6;0%)), which results any error to be shown as 0%.

My problem:

How could I integrate IF formula with IFERROR, so that if everytime the result is 100%, the result would still show 0%. Or is there another formula I could use?

Thanks alot,
Marty

2. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

Do you only want to do that if the result is exactly 100%, what if it's 101%...or 200% or 300%?

3. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

Try:

=IF(ISERROR((D6-C6)/C6);0%;IF((D6-C6)/C6=100%;0%;(D6-C6)/C6))

4. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

Yeah, only if the result is 100,00%

5. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

@NBVC:

It doesn't seem to work, still shows 100%.

6. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

Did you check if the result of (D6-C6)/C6 is exactly 100% (i.e. is it formatted to show no decimals)?

7. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

@NBVC:

Oh, it was -100% I noticed. Thanks alot for your help

Case solved

8. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

You should only get 100% if D6 is exactly double C6 therefore

=IFERROR(IF(D6/C6=2;0;D6/C6-1);0)

9. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

Advance button wont work when editing the first post. Cant change it to solved...

10. ## Re: IF in IFERROR, need the result to be 0% if there is an error or the answer is 100

I did it for you.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1