C
curious
Is there a way to format the totals to divide by .85 and then total?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Which totals? Your own, or Excel's subtotals? A bit more information
required, methinks.
required, methinks.
B
Bob Phillips
Why not just
=SUM(rng)/.85
=SUM(rng)/.85
S
Stuart Y.
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.
multiplying by .85 youll get a really big number the other way.
C
curious
curious said:Is there a way to format the totals to divide by .85 and then total?
I understand what I need now. Thank you for replying. I wanted to have
column a + b = c and c divided by .85 = d
anyway, the formula i came up with was =c1/.85
and it worked!
ya learn somethin new every day!