#Value!
 

How would i write this formula to keep this error from showing up, Thanks in
advance!

#Value!
 

What's the formula?


--
Biff
Microsoft Excel MVP


"Richard" wrote in message
...
How would i write this formula to keep this error from showing up, Thanks
in
advance!

#Value!
 

=(G3/$L$1)+$D$1

"T. Valko" wrote:

What's the formula?


--
Biff
Microsoft Excel MVP


"Richard" wrote in message
...
How would i write this formula to keep this error from showing up, Thanks
in
advance!

#Value!
 

=(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.


--
Biff
Microsoft Excel MVP


"Richard" wrote in message
...
=(G3/$L$1)+$D$1

"T. Valko" wrote:

What's the formula?


--
Biff
Microsoft Excel MVP


"Richard" wrote in message
...
How would i write this formula to keep this error from showing up,
Thanks
in
advance!