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.

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.

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.