ISERROR Function - Too many arguments: Please Help!!

[anna82marie]

I'm having an issue trying to get the following formula to return N/A instead of #VALUE!

=IF($K8>$F$5,(TODAY()-$K8)*($O8*0.2739726%),(TODAY()-$F$5)*($O8*0.2739726%))

Can anyone help me to do this? I can't get my head around it at all and have a deadline looming. Any help would be really appreciated!!

 

[Joe4]

Welcome to the Board!

Which version of Excel do you have?
If you have 2007 or newer, you can use IFERROR, i.e.
=IFERROR(IF($K8 > $F$5,(TODAY()-$K8)*($O8*0.2739726%),(TODAY()-$F$5)*($O8*0.2739726%)),"N/A")

 

[anna82marie]

It's 2007, so I will give your formula a try! Thank you

 

[Joe4]

The IFERROR formula was a nice addition to Excel. Basically, it just tells it what to return in the event of an error. If there is no error, just return the result of the formula (see here for structure: IFERROR function - Excel - Office.com).

In earlier versions, you would have to use IF and ISERROR in conjunction, and have to repeat your formula twice (once to check for the error, and once to return the value if there is no error). Much longer, clunkier, messier.