Make #Value! error blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I make the #Value! error not show up. Here are the two functions I use which generate the error

=IF(OR(V14="",T14=""),"",(V14-T14)

=IF(AG11+AH11=0,"",IF(U11+V11=0,"",((AG11+AH11)-(U11+V11))))*24*6

Any assistance appreciated

Thanks,.......
 
Hi,
Use =iserr() or =iserror () f-lae
for example,
=if(Or(iserr(v14),iserr(t14),"",your original formula here)

HTH
Puzatiy Popandopulo
-----Original Message-----
How can I make the #Value! error not show up. Here are
Click to expand...
the two functions I use which generate the error:
 
Thanks for the assistance guys........

----- Frank Kabel wrote: ----

Hi Rus
try something lik
=IF(ISERROR(your_formula),"",your_formula

Fran

Russ wrote
 
Back
Top