Getting rid of #num error when blank cell included in formula

**moorelm** · 10-16-2009, 01:02 AM

I'm trying to format a cell so that it has the formula in it so when data is entered into the referenced cells it will calculate. It's an if statement and also using the duration formula for the value if false, however in the duration formula is where it is referencing blank cells and it shows the #num error. Is there anyway around this inconvience whether it be by formula or another way to write it or whatever. My current formula for the cell is:
=IF(E9="","",DURATION(39448,(39448+(E9*365)),F9,H9,1,))

If I knew how to take a screen shot and upload it on here I would so what I'm doing can be seen.

I hope my question is understandable and I'd appreciate any help on this. Thanks!

**pike** · 10-16-2009, 01:53 AM

Hi moorelm
I think this is what you need
IF(iserror(DURATION(39448,(39448+(E9*365)),F9,H9,1,))),"",DURATION(39448,(39448+(E9*365)),F9,H9,1,))

**DonkeyOte** · 10-16-2009, 02:44 AM

If you're using XL2007 you can utilise the new IFERROR function thereby avoiding need to double evaluate

=IFERROR(DURATION(39448,(39448+(E9*365)),F9,H9,1,),"")