|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 16th, 2009, 01:42 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error Message :A value used in the formula is of the wrong data ty
Just upgraded to Office 2007, trying to do a very basic spreadsheet and keep
getting the above error message, and I cant see why ? I have a column, with values in A6:A9, I want to add these together and then subtract the total from a value in A10. I'm using =Sum(A10-(A6:A9)), but keep getting the above error ? All cells are formatted as General Numbers to 2 decimal places. Can anyone help please ? 
|
|
#2
June 16th, 2009, 01:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error Message :A value used in the formula is of the wrong data ty
Use:
=A10-Sum(A6:A9) HTH Otto "Graham" wrote in message ... Just upgraded to Office 2007, trying to do a very basic spreadsheet and keep getting the above error message, and I cant see why ? I have a column, with values in A6:A9, I want to add these together and then subtract the total from a value in A10. I'm using =Sum(A10-(A6:A9)), but keep getting the above error ? All cells are formatted as General Numbers to 2 decimal places. Can anyone help please ?
|
|
#3
June 16th, 2009, 01:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error Message :A value used in the formula is of the wrong data ty
You're format is wrong. Try:
=A10-SUM(A6:A9) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Graham" wrote: Just upgraded to Office 2007, trying to do a very basic spreadsheet and keep getting the above error message, and I cant see why ? I have a column, with values in A6:A9, I want to add these together and then subtract the total from a value in A10. I'm using =Sum(A10-(A6:A9)), but keep getting the above error ? All cells are formatted as General Numbers to 2 decimal places. Can anyone help please ?
|
|
#4
June 16th, 2009, 02:31 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error Message :A value used in the formula is of the wrong dat
Thank you both, mislead by the error message!!
"Otto Moehrbach" wrote: Use: =A10-Sum(A6:A9) HTH Otto "Graham" wrote in message ... Just upgraded to Office 2007, trying to do a very basic spreadsheet and keep getting the above error message, and I cant see why ? I have a column, with values in A6:A9, I want to add these together and then subtract the total from a value in A10. I'm using =Sum(A10-(A6:A9)), but keep getting the above error ? All cells are formatted as General Numbers to 2 decimal places. Can anyone help please ?
|
|
#5
June 16th, 2009, 03:51 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Error Message :A value used in the formula is of the wrong dat
Hi,
This is interesting but - in 2007 you get an answer with your original formula without getting an error but in 2003 you get the #VALUE! error. However, in both version Excel will calculate a number for your formula if you enter it as an array (Ctrl+Shift+Enter). But in that case Excel thinks you want to perform the following calculations SUM(A10-A6,A10-A7,A10-A8,A10-A9) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Graham" wrote: Thank you both, mislead by the error message!! "Otto Moehrbach" wrote: Use: =A10-Sum(A6:A9) HTH Otto "Graham" wrote in message ... Just upgraded to Office 2007, trying to do a very basic spreadsheet and keep getting the above error message, and I cant see why ? I have a column, with values in A6:A9, I want to add these together and then subtract the total from a value in A10. I'm using =Sum(A10-(A6:A9)), but keep getting the above error ? All cells are formatted as General Numbers to 2 decimal places. Can anyone help please ?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
