Values

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-courses · Excel-courses-london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Values

Catherine has attended:
Excel Introduction course

by - delegate Catherine [2 posts] (2008 Feb 13 Wed, 18:48) Reply

After entering a formula in a destination cell, the answer is appearing as #VALUE! What have I done wrong?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Values

by - trainer Mark gold contributer [151 posts] (2008 Feb 18 Mon, 16:17) Reply

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@microsofttraining.net

Glad to help you

Mark East

· Customized Financial Excel Courses in London
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· MS Excel: Excel At Making The Most Of Your Christmas
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
microsoft-excel-courses and other Microsoft training courses.

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips