Calculating percentage from one column [Solved/Closed]

Report
-
 Judy -
Hello,


I am trying to calculate the simple sales commission. I entered the sales amount starting C8 and will continue below. Starting D8, I need to get 10 % of C8 Data.
Not only for C8... C9...C10..............fore every rows


1 reply

Posts
21
Registration date
Thursday July 23, 2009
Status
Member
Last seen
April 6, 2012

Do you have a maximum range (end column)?

=SUM(C8:C1000)*0.1
This is not working. I am sorry that I cant explain it right.
I have numbers entered on C8, C9, C10......................(It doesn't have maximum range).
I want to get 10% of C8, C9, C10...... goes on to D8, D9, D10.........
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
762
Have you tried in D8

= C8 * 0.1
Just enter that in D8 and then drag it down to last row of your data

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!