#Value

  • Thread starter Thread starter Margo Hoffmann
  • Start date Start date
M

Margo Hoffmann

I need to add 2 cells (E24+E44), how can I achieve this
without getting #Value when zero value?
 
Hi Margo,
Check your data. The only way you should be getting
#Value is if a number is actually being interpreted as
text instead of a value. The data in either E24 or E44
has to be text instead of a value.
 
You must log in or register to reply here.

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

#DIV/0! problem 4
Formulas 3
Formula/Shipping Chart 4
Index match within sumproduct 2
vlookup problem 7
Conditional formatting 3
WorksheetFunction not working correctly 1
repost: How do I activate an option button? 2

Back
Top