+ Reply to Thread
Results 1 to 3 of 3

Multiplying measurements from the same cell

  1. #1
    Registered User
    Join Date
    03-26-2010
    Location
    London,England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Multiplying measurements from the same cell

    Hi everyone,

    Hopefully a couple of nice easy ones for you all on a Friday.

    1) Within a single cell I have a measurement - 150mm(w) x 300mm(h). I wish to multiply each one of these values by a different number eg 150x5 and 300x6.

    How would I do this with a formula? - I am having trouble getting the formula to recognise the 150 and 300as individual numbers

    2) Within another single cell I have another measurement 28x10. How do I multiply these two numbers together in a second cell without having to input them manually.

    Thanks a lot

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848

    Re: Multiplying measurements from the same cell

    For #1 how are the 5 and 6 entered? Are they in their own cells? How is the result to be displayed?

    For #2
    Please Login or Register  to view this content.
    Last edited by mdbct; 03-26-2010 at 10:21 AM. Reason: added another question for #1

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: Multiplying measurements from the same cell

    1/.
    Please Login or Register  to view this content.
    will get 150*1 Change *1 to *2 etc
    Please Login or Register  to view this content.
    will get 300*1 Change *1 to *2 etc

    2/.
    Please Login or Register  to view this content.
    will return 84

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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