IFERROR WITH CALCULATION FORMULAS

[janema]

I am just having the worst time with getting formulas to work today

In column AC, I am just trying to get the formula to return BLANK if it is an error or there is no data in column Z (or if result is zero). But I keep getting an error message that there are too many arguments.

My formula is currently:

=IF((Z4/X4)=0,"","",IFERROR(Z4/X4),"", Z4/X4))

 

[Joe4]

Try this:

=IF(OR(Z4=0,X4=0),"",Z4/X4)

 

[janema]

Try this:

=IF(OR(Z4=0,X4=0),"",Z4/X4)

That works to eliminate the zeros, but not for errors. Still getting some #N/A results.

 

[Joe4]

That works to eliminate the zeros, but not for errors. Still getting some #N/A results.

You shouldn't, unless you have some non-numeric values in cells X4 and Z4. If you have 0 or nothing in there, it should work.
What exactly do you have in cells X4 and Z4 when you get these errors?

 

[janema]

You shouldn't, unless you have some non-numeric values in cells X4 and Z4. If you have 0 or nothing in there, it should work.
What exactly do you have in cells X4 and Z4 when you get these errors?

It is either blank or a dollar amount, but there are also errors (#N/A) so that's why using the 0 in formula only eliminates the blanks

 

[Sufiyan97]

Try

=IFNA(IF(OR(Z4=0,X4=0),"",Z4/X4),"")

 

[Dave4m]

Try this:
IF((Z4/X4)=0,"",IFERROR(Z4/X4,""))