On Tue, 28 Mar 2006 01:12:28 -0800, Roger wrote:

On 27 Mar 2006 19:31:16 -0800, "RobW" wrote:

The #value! error appears when a formula tries to use inputs including
non-value items.
e.g. =a2+b2, where a2 is "hi there".

Can you check and fix the 'input' cells to remove non-value items?
This will flow through and fix the #value errors.

Otherwise, try =if(ISERROR(your formula),"",your formula).

This is the formula:

=(($A$1*660)-K8*10)/L8

where a1=8.5
k8=nothing (not the word "nothing" but no value)
L8=nothing

When I insert =if(iserror into the formula I get #name?

=IF(iserror,(($A$1*660)-K8*10)/L8)

Thank you.

OK, good news. I just fixed it by doing the following:

=IF(L8="","",(($A$1*660)-K8*10)/L8)

I'd still be interested in knowing if you can ascertain why I got the
#value! error.

Thanks, again.