Create a formula such that each cell in a given column auto

Closed
shs1954
Posts
1
Registration date
Monday August 18, 2014
Status
Member
Last seen
August 18, 2014
- Aug 18, 2014 at 05:23 PM
ExPatBrit
Posts
2
Registration date
Tuesday August 19, 2014
Status
Member
Last seen
August 19, 2014
- Aug 19, 2014 at 03:24 PM
Hello,

Is there a way to create a formula such that each cell in a given column automatically calculates a specific percentage of the value in the adjacent cell. Example G3 says $1.99. Want H3 to automatically show a percentage (39%) of that value in H3 (.78).

The formula should be written such that all the cells in Column H show the percentage of the value in the adjacent Column G cell, which varies from cell to cell.

Is this possible?

Thanks,
John

1 reply

ExPatBrit
Posts
2
Registration date
Tuesday August 19, 2014
Status
Member
Last seen
August 19, 2014

Aug 19, 2014 at 03:24 PM
Is this what you mean??
Col G Col H Reqd_Pctng
1.99 0.78 39%
2.99 1.17
3.65 1.42
Cells in col H contain formula: =(ROUND(((G2)*Reqd_Pcntg),2))

Where you have defined 'Required %age' as FieldName ('Reqd_Pcntg') fixed for the whole SprdSht; or you could set up multiple 'Required %ages' (eg Reqd_Pcntg1, Reqd_Pcntg2 .....) & reference them accordingly as formulae in Col H
0