#Value!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Appreciate any assistance to resolve the following problem:

I am linking data from various Tabs in a file, adding them and dividing the
total by 1000. Then I copy and paste the formula and values to other adjacent
cells on the spreadsheet. Problem is in some cases I get subject error
message. I have checked the formulas, cell properties (format) and cannot
seem to find the problem.I have even tried Auditing (Not sure how to go about
it). Appreciate any assistance that can relieve me of this problem.
 
If you are trying to calculate with a text you will get a value error, so I
assume some of the values you are linking are either blank from formulas ""
or a space unless they are a visible text string. Check one of the linked
values with =ISNUMBER(Sheet3!A3) (replace the sheet and cell reference with
the real one). If you get FALSE it is text
 
Back
Top