| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formulas
Is there a way to format the totals to divide by .85 and then total?
|
|
#2
|
|||
|
|||
|
Which totals? Your own, or Excel's subtotals? A bit more information
required, methinks. -- Andy. "curious" wrote in message ... Is there a way to format the totals to divide by .85 and then total? |
|
#3
|
|||
|
|||
|
Why not just
=SUM(rng)/.85 -- HTH Bob Phillips "curious" wrote in message ... Is there a way to format the totals to divide by .85 and then total? |
|
#4
|
|||
|
|||
|
Do you really want to divide by .85 or get 85%. cause that would be
multiplying by .85 youll get a really big number the other way. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| Formulas | Excel Worksheet Functions | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
