Turning Cell values into percentages and keeping original value in same cell

[alboi]

Hi,
I'm using Excel 2003. I have a table with values entered and then a total at the right corner. I would like to turn the numbers in each of these cells into a percentage of the total value in cell O17, which has a value of 318.
For example, cell B10 shows a value of 4. I would like to know what percentage of 318 (Cell O17) is 4 (Cell B10). What would be the best formula to apply to all cells in the table except cell O17?
My second problem is that I also want the value 4 to show next to the percentage. 4 is 1.26% of 318. But in the same cell, Cell B10, I want the value 4 and 1.26% to show alongside each other. Is there any way to do that?
Thank you for all help you give me,
Alboi

 

[Scott Huish]

Hi, welcome to the board!

First question:

=B10/O17

Format as percent, with the desired number of decimal places.

With a formula, no, you can't enter the data in B10 and have the answer appear with it.

It could be done with VBA, if that's what you want.

Sub test()
If IsNumeric(Range("B10")) And Range("B10") <> "" Then Range("B10") = Range("B10") & "/" & Format(Range("B10") / Range("O17"), "0.00%")
End Sub

 

[jolivanes]

How about this, but NOT in the same cell. If you change the cell value, the sum (total) will change.

=ROUND(B10,2)&" - "&ROUND(B10/(O17/100),2)

 

[alboi]

Hi, welcome to the board!

First question:

=B10/O17

Format as percent, with the desired number of decimal places.

With a formula, no, you can't enter the data in B10 and have the answer appear with it.

It could be done with VBA, if that's what you want.

Sub test()
If IsNumeric(Range("B10")) And Range("B10") <> "" Then Range("B10") = Range("B10") & "/" & Format(Range("B10") / Range("O17"), "0.00%")
End Sub

Guys,
Thank you for your speedy reply.
Hotpepper, unfortunately I have no idea what you're talking about. I'm not that advanced in excel. I just do basic entries. I would just get a calculator and manually do these, but there's so many of them.

Where would I enter the code that you gave me? And what is VBA?
Thanks for helping me.

P.S.: As I'm making the tables, I realize that they are not that easy to see so I fill in alternate cells with 20% Gray from the dropdown box on the right where the bucket shows. I would like it to be less gray and more clear but I see no option for customizing this color. Does anyone know how?

 

[Scott Huish]

VBA is Visual Basic for Applications, it's a programming language built into Excel

You wouldn't need VBA except for the fact that you want the original value in the cell as well as the answer. If you could use a different cell for the answer, you could just use the first formula I gave you.