Formula to display column width in pixels

[zeus]

Hello,
I would like to use a formula to have the column width in pixels displayed in the cell. I would like the formula to be dynamic so that as I change the column widths, the pixel number, as displayed by the formula, would automatically update. For Example, cell B1, C1, D1 would contain 30,20,50. I could then use a sum formula to see the total length of those 3 columns in pixels is 100.

Thank you for your thoughts!

 

[Tubal]

zeus,

Try this:

=CELL("width",A1)*7.5

Tubal

 

[zeus]

Thank you for your response, Tubal. The formula gets into trouble when it uses "width" b/c you get a rounded number. I'll end up with an approximate pixel number but I'm really needing an exact count.