#Value! How do I get rid of it?
 

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.

#Value! How do I get rid of it?
 

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.

#Value! How do I get rid of it?
 

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

#Value! How do I get rid of it?
 

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

--

Dave Peterson

#Value! How do I get rid of it?
 

On 28 Mar 2006 02:38:42 -0800, "Pete_UK" 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