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

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.

=A30*80%

assuming totals in A30

--

HTH

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


"Full Effect Landscaping" <Full Effect
wrote in message
...
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.

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
wrote:

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.