# 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 1 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 response

ExPatBrit Posts 1 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