Simple calculation

[advmold]

Hello all,

I need to be able to get different % of a gross figure with out typing =G2*0.03 for every cell in the column. Is there a way to say look to the left 2 cells and then * .03 rather then putting in the cell number?

Thanks,
Chris


CELL 1 CELL 2 CELL 3 CELL 4
GROSS BONUS 3% BONUS 4% BONUS 5%

66466.41 1993.99 4% of cell 1 5% of cell 1

 

[just_jon]

Welcome to MrExcel - is there a reason you wish not to use formulas?

Can be done other ways, but formulas quicker.