Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
using formula
I have created a table using formula to calculate the column totals, however
I want to cap the total to a specific number, in this case maxium mark allocation can only be 25. Is this possible? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
using formula
Hi adelevran,
You could use a formula field coded as {=MIN(25,SUM(ABOVE))}, where the field braces (ie '{}') are created via Ctrl-F9. Do be aware though, that SUM(ABOVE) is quirky. For more information on this and 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 [MVP - Microsoft Word] "adelevran" wrote in message ... I have created a table using formula to calculate the column totals, however I want to cap the total to a specific number, in this case maxium mark allocation can only be 25. Is this possible? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Formula HELP!! | Tables | |||
Formula | Tables | |||
how to align caption of formula right whereas formula itself left | Microsoft Word Help | |||
Formula Help | Microsoft Word Help | |||
Need a formula | Microsoft Word Help |