% Formulas

A

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!
 
E

Earl Kiosterud

Anna,

=B2/A3

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