IFERROR formula

[janema]

I know this is a simple formula, but it keeps telling me I have too many arguments. I just want the field to be blank if the result of this calculation is an error.

This is the calcuation:

=(G13-C13)/C13

I tried doing =IFERROR(G13-C13)/C13,"") and =IF(G13-C13)/C13=ISERROR,""), but no luck.

Any suggestions?

 

[fjns]

Hi, try this formula
=IFERROR((G13-C13)/C13,"")

 

[awoohaw]

I know this is a simple formula, but it keeps telling me I have too many arguments. I just want the field to be blank if the result of this calculation is an error.

This is the calcuation:

=(G13-C13)/C13

I tried doing =IFERROR(G13-C13)/C13,"") and =IF(G13-C13)/C13=ISERROR,""), but no luck.

Any suggestions?

You have unbalanced parentheses in the first formula.

 

[fjns]

Hi, the your second formula can also be improved:
=IF(ISERROR((G13-C13)/C13),"")

 

[Peter_SSs]

When you get an error, is it a #DIV/0! error?
If so, you could just use ..

=IF(C13,(G13-C13)/C13,"")

 

[janema]

When you get an error, is it a #DIV/0! error?
If so, you could just use ..

=IF(C13,(G13-C13)/C13,"")

This got rid of the blank, but it wouldn't calculate correctly when there are values in those fields. I get a "FALSE" result.

 

[janema]

Hi, try this formula
=IFERROR((G13-C13)/C13,"")

Thank you so much, this worked!

 

[janema]

Hi, the your second formula can also be improved:
=IF(ISERROR((G13-C13)/C13),"")

This got rid of the blank, but it wouldn't calculate correctly when there are values in those fields. I get a "FALSE" result.

 

[awoohaw]

This got rid of the blank, but it wouldn't calculate correctly when there are values in those fields. I get a "FALSE" result.

can you paste the forumula that is in your cell and tell us what values are in the two fields. Do you have the "" after the parenthese and comma?

 

[awoohaw]

actually change your formula to this:

=IF(ISERROR((G13-C13)/C13),"",(G13-C13)/C13)

or

=IFERROR((G13-C13)/C13),"")