Calculating percentage from one column

Solved/Closed

Judy - 17 Jun 2010 à 14:03
Judy - 17 Jun 2010 à 21:10

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

Calculating percentage from one column
Excel column number - Guide
How to delete a column in word - Guide
Tweetdeck expand column - Guide
Excel calculating threads - Guide
How to calculate vat percentage in excel - Guide

1 response

Réponse 1 / 1

Netscur Posts 21 Registration date Thursday 23 July 2009 Status Member Last seen 6 April 2012
17 Jun 2010 à 14:15

Do you have a maximum range (end column)?

=SUM(C8:C1000)*0.1

Judy
17 Jun 2010 à 14:49

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.........

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
17 Jun 2010 à 17:32

Have you tried in D8

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

Judy
17 Jun 2010 à 21:10

THANK YOU

Similar discussions

calculating fuel surcharge

VBA column

How do I extract specific data from a cell in excel?

Similar discussions

Subscribe To Our Newsletter!