+ Reply to Thread
Results 1 to 5 of 5

Simple Multiplication error

Hybrid View

paradise2sr Simple Multiplication error 10-23-2013, 03:47 AM
benishiryo Re: Simple Multiplication... 10-23-2013, 03:51 AM
TMS Re: Simple Multiplication... 10-23-2013, 03:54 AM
paradise2sr Re: Simple Multiplication... 10-23-2013, 04:27 AM
TMS Re: Simple Multiplication... 10-23-2013, 04:40 AM
  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Simple Multiplication error

    I have following data

    A B C D
    2kg 7.50kg 2gm 5gm

    5 7 3 6.2

    =2*A2 =7.50*B2 =2*C2 =5*D2
    10 52.5 6 31

    How to formulate a formula without using manually assigning numeric value for A1:D1 rows in A3 during calculation by A2:D2 as in A1:D1 as there is a alpha numeric that produces an error on doing so.

    Is there any way to link A1:D1.This is a sample for A2 as there are many rows which is needed to be multiplied by A1:D1 but due to alpha numeric it is difficult to do calculation as manually I have to assign numeric part for A1:D1.

    With Best Rgds,

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,156

    Re: Simple Multiplication error

    hi paradise2sr. try:
    =A2*LEFT(A$1,LEN(A$1)-2)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,102

    Re: Simple Multiplication error

    Formula: copy to clipboard
    =LEFT(A$1,LEN(A$1)-2)*A2



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2024
    Posts
    1,384

    Re: Simple Multiplication error

    Thanks all of you.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,102

    Re: Simple Multiplication error

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Simple macro for multiplication/division
    By Oilandgasmonkey in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-07-2012, 07:29 PM
  2. Converting simple multiplication formula in VBA code
    By Saky in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-07-2010, 07:33 AM
  3. A Simple Multiplication....plz help
    By ZarrinPour in forum Excel General
    Replies: 4
    Last Post: 06-27-2010, 03:32 AM
  4. Excel Can't Multiply...why is simple multiplication incorrect?
    By JBeaucaire in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2008, 11:55 PM
  5. [SOLVED] Multiplication error
    By DeeJay in forum Excel General
    Replies: 8
    Last Post: 07-20-2005, 05:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1