Absolute Reference
 

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

hi,

Just remove the $ sign

"Aziz" wrote:

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

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=472071