Excel calculate hra cca da only

Closed
nick_sh05@yahoo.com - Aug 9, 2009 at 09:36 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 10, 2009 at 06:38 AM
Hello,
i have a worksheet with the following column
a b c d e f g
s.no name basic hra cca da net
1 ajay 20000 20% 15% 35%
2 raj 15000
3 ram 250000


question: the formula for calculating the above three is to be entered only once in cell d4 and then copied to the other cell on the right and down below.

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 10, 2009 at 06:38 AM
=$C4*d$3
10