% Formulas

[Anna]

Does anyone know how to translate a value (£) into a percentage of a
larger value (£).

e.g
Cell A
£500
Cell B
£50
Cell C
10%

Any help would be great!

 

[Earl Kiosterud]

Anna,

=B2/A3

This will yield 0.1. Format for % (% button on formatting toolbar or
Format - Cells - Number - Percent)