Precentage of Cell 2 out of Cell 1

A Rose

Hi,

What formula caculates the precentage of [Column A] row 1, out of [Column B] Row 1

Thank you!

Brett Wyrick

Hello there,

=[Column A]@row/[Column B]@row

That ought to do it. To get it to display as a percentage, you'll need to head to the top menu bar and select that.

(use the Percentage Format button in the toolbar)

Brett Wyrick

Hello there,

=[Column A]@row/[Column B]@row

That ought to do it. To get it to display as a percentage, you'll need to head to the top menu bar and select that.

(use the Percentage Format button in the toolbar)

A Rose

How would I do a 2 or 3 digit number in the result (I.e., 99% or 100% not 2.78125), and it should also have a "%" at the end?

Thank you!