Column Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
not sure I understood you correcly but put the following in I3:
=H3/B3
format this cell as percentage and copy down
 
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
 
Back
Top