#Value

[bforster1]

I have created several formulas and in the template the cells are "0
until someone fills them in. Unfortunately I am getting a "#value
error in my cells and is causing problems. Any suggestions

 

[Frank Kabel]

Hi
post your formula that creates this error

 

[Dave Peterson]

You could use:

=if(iserror(yourformula),"",yourformula)