Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula assistance
I want to take A1:A10 and multiply by .585
then... A:11:A20 multiplied by .55 = total result on A25 I went something like this....and it won't work: =sum(a1:a5)*.585+(a11:a20)*.55 All I get is #VALUE and the help prompts do not help. I am using Excel 2007 Any help appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Assistance | Excel Discussion (Misc queries) | |||
Formula assistance please??? | Excel Discussion (Misc queries) | |||
Formula assistance | Excel Discussion (Misc queries) | |||
Formula Assistance | New Users to Excel | |||
Assistance with Formula | Excel Worksheet Functions |