Values

Resolved · Low Priority · Version Standard

Wed 13 Feb 2008, 18:48 Delegate Catherine said...

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?

Mon 18 Feb 2008, 16:17 Trainer Mark said...

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:

Manually wrapping text

To manually wrap text, use the shortcut key Alt+Enter.

To cancel manual text wrapping, simply delete the new line.

View all Excel hints and tips

Values

Values

RE: Values

Excel articles

Excel tip:

Manually wrapping text