SImple FORMULA question in Excel

[Cocochina]

How to make a percentage in Excel?

I have one column, X with numbers. They go all the way to Row 250

I would like to put 3% of the number in column Z

So if X2 is 10, then Z2 is 3

I would like to put the total in AA


How can I do this?


THanks

 

[vasim]

If X2 is 10 then in Z2


=X2*3%


But what total do you want in AA

 

[Cocochina]

X plus Z


So, where do I put the formula? How to I capture all the rows in X?


THanks!

 

[anand_babu]

Hi,


If you are expecting result in a single cell try something like this..


=SUM(X1:X250)+(SUM(X1:X250)*3%)