| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I need a formula that will multiply #'s in column C by 25.37869%
I have a spread sheet of 47 rows. I need to multiply each row in column C by
25.378692%. I need the totals to appear in column D and the remaining balance to appear in column E. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
I need a formula that will multiply #'s in column C by 25.37869%
In D1:
=C1*25.378692% In E1: =C1-D1 Copy down to fill 47 rows -- Kind regards, Niek Otten Microsoft MVP - Excel "Maggie" wrote in message ... I have a spread sheet of 47 rows. I need to multiply each row in column C by 25.378692%. I need the totals to appear in column D and the remaining balance to appear in column E. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
I need a formula that will multiply #'s in column C by 25.37869%
Hi,
in D1 enter =C1*0.25378692 copy formula down and in E1 enter =D1-C1 "Maggie" wrote: I have a spread sheet of 47 rows. I need to multiply each row in column C by 25.378692%. I need the totals to appear in column D and the remaining balance to appear in column E. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I multiply either column 1 or column 2 by same multiplier? | Excel Worksheet Functions | |||
| How to multiply column and rows | Excel Discussion (Misc queries) | |||
| Operations (add, multiply) on all values ($00.00) in a column? | Excel Discussion (Misc queries) | |||
| Divide Column A by Column B multiply Column C | Excel Worksheet Functions | |||
| How do I multiply a whole column by a number? | Excel Worksheet Functions | |||
Linear Mode
