Catherine has attended:
Excel Introduction course
Values
After entering a formula in a destination cell, the answer is appearing as #VALUE! What have I done wrong?
RE: Values
Hi Catherine
Hope you are ok.
Now the answer to your question could be varied because it depends on the formula you are trying to do, if this is a basic formula.
Check a couple of things first 1, you are you brackets if you are trying to do a SUM type formula, if not then make sure you have the correct operators in the formula, i.e.
= + - * / or even that you have : collons in the right place and remember that if you open brackets you must also close them
If you need further info please email me at
mark@stl-training.co.uk
Glad to help you
Mark East