How do I subtract 20% from one column in Excel and place totals i.

G

Guest

I would like to know if someone knows the formula I use to subtract 20% from
totals in one column on my spreadsheet to show totals in another column on
same spreadsheet. Can anyone help? Spent way to long trying to figure out
correct formula.
 
B

Bob Phillips

=A30*80%

assuming totals in A30

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Full Effect Landscaping" <Full Effect
(e-mail address removed)> wrote in message
news:[email protected]...
 
M

Myrna Larson

YOu've been given the correct formula, but to follow your word description, it
would be =A1-(20%*A1)


On Tue, 1 Feb 2005 09:29:08 -0800, "Full Effect Landscaping" <Full Effect
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtracting multiple columns from another column 3
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
how to carry forward a total from one page to another 3
Referencing a pivot tables Grand Totals Column 1
How do I sum numbers based on other data 6
lookup using column headers and row headers 1
Add/Subtract columns from tab to tab in same file 3
Trailing 30 days sum calculation with excel 1

Top