Excel calculate hra cca da only

Closed
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
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 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
=$C4*d$3
10