create a formula such that each cell in a given column auto Closed

Question

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

ExPatBrit · Answer

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

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

1 response

Similar discussions

Subscribe To Our Newsletter!