IFERROR Too few arguments

[mactoolsix]

Excel 2010
My formula:
=(AF$8*AF$7)-SUM(AK$5:AK10)-AL10 creates a #VALUE ! error due to AL10 being a blank cell. If I change AL10 to a value it will fill the column with "0.00", and then the next column with zeros also, which I'm trying to avoid simply to present a cleaner spreadsheet.

I was going to reformat the column as CUSTOM 0;;;@ which then hides zeros, but that also deletes the 2 decimal places in that column.

I tried this formula:
=IFERROR((AF$8*AF$7)-SUM(AK$5:AK10)-AL10),"") to blank out the error, however it has too few arguments.
Is there a simple way to add an argument to this, which would make the IFERROR function work?

Thanks, Mike

 

[jtakw]

Hi,

You just had an extra bracket:

=IFERROR((AF$8*AF$7)-SUM(AK$5:AK10)-AL10,"")

Edit: you also don't need the first bracket set:

=IFERROR(AF$8*AF$7-SUM(AK$5:AK10)-AL10,"")

 

[mactoolsix]

Hi,

You just had an extra bracket:

=IFERROR((AF$8*AF$7)-SUM(AK$5:AK10)-AL10,"")

Edit: you also don't need the first bracket set:

=IFERROR(AF$8*AF$7-SUM(AK$5:AK10)-AL10,"")

Thank you jtakw!!

 

[jtakw]

You're welcome, glad to help.

 

[RoryA]

I was going to reformat the column as CUSTOM 0;;;@ which then hides zeros, but that also deletes the 2 decimal places in that column.

FYI you could have used 0.00;;;@