Absolute Reference

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

Guest

I have calculated salary for one employee using =$A$2* 45 %. Now I want to
drag this for all employees, but Fill Handle does not work
Please help me
 
Good afternoon Aziz

Take the $ signs out so the formula references just A2 rather than A$2
(or only make the column absolute ($A2) and then copy it down.

HTH

Dominic
 
Back
Top