% 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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match table shading (color) to Visio color/Transparency 1
Cumulative formula for word table 0
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Remove numbers from brackets 0
Copy addition formula of non-consecutive horizontal cells 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Custom Number sequences 0

Top