Column Formulas

B

B N Mabey

With a range in a columns how do you set up a formula for the range
=F3*G3 In H
=F4*G4 In H
=F5*G5 In H

Then take H3, and calculate a percntage from B3, in I3
 
F

Frank Kabel

Hi
not sure I understood you correcly but put the following in I3:
=H3/B3
format this cell as percentage and copy down
 
P

Peter atherton

To calculate H3 as a percentage of B3 use =H3/B3%
If you intend to make further calculations bas on the
percentage use
=ROUND(H3/B3%,2)

Regards
Peter
 
Top