Re: #Value! How do I get rid of it?

On 27 Mar 2006 19:31:16 -0800, "RobW" <[email protected]> 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.

On Tue, 28 Mar 2006 01:12:28 -0800, Roger <[email protected]> wrote:

>On 27 Mar 2006 19:31:16 -0800, "RobW" <[email protected]> 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.

You were trying to divide by L8, which you said was nothing. Your
amended formula has detected that. If you wanted the ISERROR function
to work, you should have done this:

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

Hope this helps.

Pete

If you select L8 and hit the delete key, does your original formula work?

I'm guessing that the cell wasn't really empty.

Roger wrote:
>
> On Tue, 28 Mar 2006 01:12:28 -0800, Roger <[email protected]> wrote:
>
> >On 27 Mar 2006 19:31:16 -0800, "RobW" <[email protected]> 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.

--

Dave Peterson

On 28 Mar 2006 02:38:42 -0800, "Pete_UK" <[email protected]> wrote:

>You were trying to divide by L8, which you said was nothing. Your
>amended formula has detected that. If you wanted the ISERROR function
>to work, you should have done this:
>
>=IF(ISERROR((($A$1*660)-K8*10)/L8),"",(($A$1*660)-K8*10)/L8)
>
>Hope this helps.
>
>Pete

So you're saying that if there is a formula in the cell L8 then that
isn't really nothing? Or are you saying that you can't divide by 0?

>If you select L8 and hit the delete key, does your original formula work?

>I'm guessing that the cell wasn't really empty.


Same question I guess. There was a formula in L8, but there wasn't a
value because it was on a blank line.

Just trying to understand. Thanks for the help.

Roger