Getting a total number from a percentage.

[Jon1995]

Hi all,

I have attached a screenshot of what I want to do. Essentially, I want to populate Column G with numbers which relate to percentages in Column J, they are percentages of the number displayed in cell G28. I found this hard to explain so if you need any more information, please let me know.

Thanks
Jon

 

[etaf]

=$G$28*J9
with give you 20% of 265

copy down to the other rows G17 & G26

is that what you meant ?

 

[Jon1995]

Yes, that worked perfectly, thankyou!

 

[etaf]

you are welcome