MS Excel Formula

[NB Diamonds]

Machan,
Excel wala me pahala thiyena formula dekatama result eka same
but

ekathanaka "$" mark eka dala thiyenawa.
aye mehema danne, wenasa mokadda ?

=C$45*C47

=C45*C47

amount eka $ 375.61 ( C45 cell )
exchange rate eka 131.8206 ( C47 cell )

Result eka = Rs 49,512.66


poddak wisthara athuwa kiyala denna.

tks for the help.

 

[NB Diamonds]

bump.

 

[rsami]

Machan,
Excel wala me pahala thiyena formula dekatama result eka same
but

ekathanaka "$" mark eka dala thiyenawa.
aye mehema danne, wenasa mokadda ?

=C$45*C47

=C45*C47

amount eka $ 375.61 ( C45 cell )
exchange rate eka 131.8206 ( C47 cell )

Result eka = Rs 49,512.66


poddak wisthara athuwa kiyala denna.

tks for the help.

$ sign eka danne mchn cell eka fix karanda. 1st formula eka uba pahalata drag karoth C$45 kiyan cell eke tiyena value eka C48 cell eke tiyena value ekath ekka wadiwenawa.
2nd formula eka pahalata drag karoth C46 kiyana cell eke tiyena value eka thama C48 ekka multiply wenne

 

[NB Diamonds]

$ sign eka danne mchn cell eka fix karanda. 1st formula eka uba pahalata drag karoth C$45 kiyan cell eke tiyena value eka C48 cell eke tiyena value ekath ekka wadiwenawa.
2nd formula eka pahalata drag karoth C46 kiyana cell eke tiyena value eka thama C48 ekka multiply wenne

tnks a lot machan.
mama meka study karannam.

 

[rtmayura]

c කියන colomn එක වෙනස් වුනත් 45 cell එක වෙනස් නොවෙන්න කියළ දාන විදිහ