Do you mean the cell value will have a numeric value preceded by "Rs.
"? If so, something like this should work:
Rs. 5 is in cell A2. Rs. 10 is in cell B2.
Operand1 Operand2 Sum
formula
Result
Rs. 5 Rs. 10 =RIGHT(A2,LEN(A2)-find(" ",A2))+RIGHT(B2,LEN(B2)-find("
",B2)) = 15
Product
Formula
=RIGHT(A2,LEN(A2)-find(" ",A2))*RIGHT(B2,LEN(B2)-find(" ",B2))
= 50
These formulas assume there will always be a space character preceding
the numeric portion of the cell. If there isn't, the formulas will
fail.
Regards,
Phil
On Dec 16, 12:36 pm, santanu_ca <santanu...@gmail.com> wrote:
> I want to Add two digit or multiply as this way.
>
> Column A Column B
> Rs. 5.00 Rs. 10.00 = Can I sum two cells by formula ?
> Rs. 5.00 Rs. 10.00 = Can I multiply Two Cells by formula ?
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
