Results 1 to 6 of 6

Thread: Worksheet for multiplication and drop down

  1. #1

    Worksheet for multiplication and drop down



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,436
    Articles
    0
    Excel Version
    Excel 2016
    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?


  3. #3
    Ya sir find it in my new attached worksheet with some suggestions and descriptions

    thanks
    Attached Files Attached Files

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,436
    Articles
    0
    Excel Version
    Excel 2016
    Try:

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

    copied down.


  5. #5
    @NBVC Sorry to but in, but I just had to say that I think that is a beautiful formula. Very simple and very elegant.

  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,436
    Articles
    0
    Excel Version
    Excel 2016
    Thanks Beamer


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •