Worksheet for multiplication and drop down

A

Anmol786

New member
Joined
Oct 7, 2014
Messages
36
Reaction score
0
Points
0
Suppose i have a worksheet (like one attached) here

In D coloumn price of each item is written but it has Rs. means it has become text data
i want that amount before Rs. to be multiplied with figures in Column E
how can i avoid text Rs. and multiply with only figures plz like 120 Rs. means only 120'

(2) i want formula in F as multiplication of Columns D And E but i want that formula in the column if some thing is written in that row or it should be omitted if nothing in row. like in B7 to E7 how can i do that plz show
 

Attachments

  • my rates.price.xlsx
    8.2 KB · Views: 9
in column D you have actually something like 5-60 R's. what part is the number you want to use? the 5 or the 60?
 
Ya sir find it in my new attached worksheet with some suggestions and descriptions

thanks
 

Attachments

  • my rates.price.xlsx
    8.4 KB · Views: 13
Try:

=IF(D6="","",E6*SUBSTITUTE(SUBSTITUTE(D6,"Rs.",""),"-","."))

copied down.
 
@NBVC Sorry to but in, but I just had to say that I think that is a beautiful formula. Very simple and very elegant.
 
You must log in or register to reply here.
Back
Top