Absolute Reference

A

Aziz

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
 
D

dominicb

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top