help with formula. It works but empty cells show#VALUE

**nje** · 10-22-2012, 03:49 PM

I have attached a sample workbook and in it I have surprised myself by ammending a formula, it works but when the cell is empty I get #VALUE in the cells, I would like the cells to be empty. It's difficult to explain but it is obvious if you would take a look at my sample.
Thank you.

**Melvinrobb** · 10-22-2012, 03:52 PM

you need to use the IFERROR function.
replace your formula in column E with the following:
=IFERROR(IF($G6="","",SUM($G6+$F6))+IF(D6="Utilities",+$H$3),"")

**nje** · 10-22-2012, 03:57 PM

WOW! Thanks very much, that solved it in what must be a record time, I'd only just posted and the solution was there

**DiggingDeeper** · 10-22-2012, 04:00 PM

Thanks Melvinrobb, that is the tidiest solution for that problem that I have seen

**daddylonglegs** · 10-22-2012, 04:11 PM

You don't really need IFERROR here, you get #VALUE! error because when G6 is blank you are trying to add FALSE from the second IF function to "" - try a subtle re-arrangement of the syntax

=IF($G6="","",SUM($G6,$F6)+IF(D6="Utilities",$H$3))