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]

Thank you so much, this worked!

Hi, I am very glad that the formula works.
If I have enough knowledge, I am happy to help at any time.

 

[fjns]

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

You're absolutely right. In this case, the FALSE result means to us that there is no error in the formula (G13-C13)/C13. In message #10, the formula of awoohaw is absolutely correct. The formula =IF(ISERROR((G13-C13)/C13),"",(G13-C13)/C13) calculates correctly if there are values in those cells.

 

[Peter_SSs]

=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.

I don't see how that formula could produce a result of FALSE. I'd be interested to know what was in C13 and G13 to produce such a result.