#Value

M

Margo Hoffmann

I need to add 2 cells (E24+E44), how can I achieve this
without getting #Value when zero value?
 
E

Eva Shanley

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.
 

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
Auto populate value from one task to another in MS PROJECT 0
Autonumber field in Excel that behaves the same as Access 0
Newbie Help - IF Yes No Function 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
VBA Coding Help for Beginner 0

Top