| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
