Get rid of #value when numbers removed from spreadsheet

[Ando999]

Hi I have the following formulae in a cell related to a worksheet.

=IF($E29="Yes",0,IF(EC29=0,0,(IF($FE$19=0,EC29,EC29+EC29/$FE$20*$FE$19))))


When I remove the 0 from the cells its looking at in column FE it returns a #value. How can I get rid of this and allow cells in FH to be blank and not return # value?

Thanks

 

[Canapone]

Hi,

in Excel 2007 you could use IFERROR

=IFERROR(IF($E29="Yes",0,IF(EC29=0,0,(IF($FE$19=0,EC29,EC29+EC29/$FE$20*$FE$19)))),"")

Hope it helps

 

[Ando999]

Thanks for this. however, this leaves me with a error - #NAME? in the cell. Any further thoughts?