Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Advanced calculations in tables--Question 2
On the Invoice Template I have, there is a column showing the number of hours worked on a given day. I know I can use a formula like =sum(C1:C7), if I have exactly 7 days worked. But the number of days on a bill varies, and often I add lots of rows to the bill, so the column length can vary from 3 to 20. Still, I'd like to have a formula in my template that simply adds up all the cells above the formula, regardless of how many there end up being. Is there any such thing? Thanks. ddc |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Advanced calculations in tables--Question 2
On Wed, 30 Sep 2009 09:52:02 -0700, DeeDeeCee
wrote: On the Invoice Template I have, there is a column showing the number of hours worked on a given day. I know I can use a formula like =sum(C1:C7), if I have exactly 7 days worked. But the number of days on a bill varies, and often I add lots of rows to the bill, so the column length can vary from 3 to 20. Still, I'd like to have a formula in my template that simply adds up all the cells above the formula, regardless of how many there end up being. Is there any such thing? Thanks. ddc You can use the formula =SUM(ABOVE). But be aware of a few possible problems with that, as described in http://www.word.mvps.org/FAQs/AppErr...eIncorrect.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Advanced calculations in tables--Question 2
To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at:
http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "DeeDeeCee" wrote in message ... On the Invoice Template I have, there is a column showing the number of hours worked on a given day. I know I can use a formula like =sum(C1:C7), if I have exactly 7 days worked. But the number of days on a bill varies, and often I add lots of rows to the bill, so the column length can vary from 3 to 20. Still, I'd like to have a formula in my template that simply adds up all the cells above the formula, regardless of how many there end up being. Is there any such thing? Thanks. ddc |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Advanced calculations in tables--Question 2
Thanks, Mr. Pod. Your site is truly great, and I've saved both the document
on Word Math Fields and the web-address for future use. "macropod" wrote: To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "DeeDeeCee" wrote in message ... On the Invoice Template I have, there is a column showing the number of hours worked on a given day. I know I can use a formula like =sum(C1:C7), if I have exactly 7 days worked. But the number of days on a bill varies, and often I add lots of rows to the bill, so the column length can vary from 3 to 20. Still, I'd like to have a formula in my template that simply adds up all the cells above the formula, regardless of how many there end up being. Is there any such thing? Thanks. ddc |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Advanced calculations in tables--Question 2
Hi Macropod, what an awesome doc need to know how I can round down a decimal
point my formula is SUM(ABOVE)*.14 amd I need to round down if the result is under 0.05. All the examples I have seen and tried round to a full number. Thanks Sam "macropod" wrote: To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "DeeDeeCee" wrote in message ... On the Invoice Template I have, there is a column showing the number of hours worked on a given day. I know I can use a formula like =sum(C1:C7), if I have exactly 7 days worked. But the number of days on a bill varies, and often I add lots of rows to the bill, so the column length can vary from 3 to 20. Still, I'd like to have a formula in my template that simply adds up all the cells above the formula, regardless of how many there end up being. Is there any such thing? Thanks. ddc |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Advanced calculations in tables--Question 2
Hi Sammy,
Perhaps the simplest way is to divide the number by the precision you require, before getting the integer value, then multiply the integer value by that same precision afterwards. For example: {=INT(SUM(5.53244,6.67432,7.75021)/0.05)*0.05 \# 0.00000} returns 19.95, whereas the unrounded value is 19.95697 -- Cheers macropod [Microsoft MVP - Word] "Samy" wrote in message ... Hi Macropod, what an awesome doc need to know how I can round down a decimal point my formula is SUM(ABOVE)*.14 amd I need to round down if the result is under 0.05. All the examples I have seen and tried round to a full number. Thanks Sam "macropod" wrote: To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "DeeDeeCee" wrote in message ... On the Invoice Template I have, there is a column showing the number of hours worked on a given day. I know I can use a formula like =sum(C1:C7), if I have exactly 7 days worked. But the number of days on a bill varies, and often I add lots of rows to the bill, so the column length can vary from 3 to 20. Still, I'd like to have a formula in my template that simply adds up all the cells above the formula, regardless of how many there end up being. Is there any such thing? Thanks. ddc |
#7
Posted to microsoft.public.word.tables
|
|||
|
|||
Advanced calculations in tables--Question 2
Thanks will give that a shot.
"macropod" wrote: Hi Sammy, Perhaps the simplest way is to divide the number by the precision you require, before getting the integer value, then multiply the integer value by that same precision afterwards. For example: {=INT(SUM(5.53244,6.67432,7.75021)/0.05)*0.05 \# 0.00000} returns 19.95, whereas the unrounded value is 19.95697 -- Cheers macropod [Microsoft MVP - Word] "Samy" wrote in message ... Hi Macropod, what an awesome doc need to know how I can round down a decimal point my formula is SUM(ABOVE)*.14 amd I need to round down if the result is under 0.05. All the examples I have seen and tried round to a full number. Thanks Sam "macropod" wrote: To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "DeeDeeCee" wrote in message ... On the Invoice Template I have, there is a column showing the number of hours worked on a given day. I know I can use a formula like =sum(C1:C7), if I have exactly 7 days worked. But the number of days on a bill varies, and often I add lots of rows to the bill, so the column length can vary from 3 to 20. Still, I'd like to have a formula in my template that simply adds up all the cells above the formula, regardless of how many there end up being. Is there any such thing? Thanks. ddc |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced calculations in tables--Question 1 | Tables | |||
calculations in tables | Tables | |||
Advanced MS Word Template Design Question: Version 2 | Microsoft Word Help | |||
Calculations in tables | New Users | |||
Calculations in tables | New Users |