#value

A

AlbertM

My formula A1*B1*C1 is giving me #value. I have determined that the problem is in B1. This value is linked to another sheet and the formatting on both sheets is the same ACCOUNTING 2 decimals. If I overtype the value in B1 it clears the error. I have tried copying formats to make it work and I cannot find anything to work. Any ideas
Thanks
 
B

Bob Phillips

Isn't B1 also showing #VALUE. If so, fix the fault in that formula. For in
stance, you could use =IF(ISERROR(formula),0,formula).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

AlbertM said:
My formula A1*B1*C1 is giving me #value. I have determined that the
Click to expand...
problem is in B1. This value is linked to another sheet and the formatting
on both sheets is the same ACCOUNTING 2 decimals. If I overtype the value
in B1 it clears the error. I have tried copying formats to make it work and
I cannot find anything to work. Any ideas?
 

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

SUMIF "value if false" not working 2
Merging cells and formats 8
Copying a cell value to another sheet by using If statement 1
Referencing the values of multiple cells in conditinal formatting. 0
COUNTING THE SAME VALUES IN A SHEET 3
Show value from one cell in another cell if today falls between a date range 5
Nameing a function 1
VBA for Dependents shortcut menu 0

Top