#Value!

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

How would i write this formula to keep this error from showing up, Thanks in
advance!
 
=(G3/$L$1)+$D$1

The only way that you'd get a #VALUE! error with that formula is if any of
the referenced cells contained a TEXT entry or if any of those cells already
contained a #VALUE! error.

Try this for a return of 0:

=IF(ISERROR((G3/$L$1)+$D$1),0,(G3/$L$1)+$D$1)


Or this to return a blank:

=IF(ISERROR((G3/$L$1)+$D$1),"",(G3/$L$1)+$D$1)

Both formulas will trap *all* errors.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Continue Excel to New Uear 9
Hide error messages? 1
is Error help 3
Excel 2007 - formula to display text over a range of values 1
Excel VBA 1
dates 4
GETPIVOTDATA #REF! error XL2003/2010 1

Back
Top