Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
values

ResolvedVersion Standard

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

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.