Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Values
Resolved · Low Priority · Version Standard
Catherine has attended:
Excel Introduction course
After entering a formula in a destination cell, the answer is appearing as #VALUE! What have I done wrong?
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
|
Excel tip:Manually wrapping textTo manually wrap text, use the shortcut key Alt+Enter. |
We'll call during UK business hours
Server loaded in 0.07 secs.