+ Reply to Thread
Results 1 to 8 of 8

Multiply formula for specific table

  1. #1
    Registered User
    Join Date
    03-21-2015
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Windows 7
    Posts
    40

    Multiply formula for specific table

    Could you please help me with formula shown in the attached excel file. I showed the result I want and wrote text "Formula" in cell so that specific formula help to multiply mentioned figures.
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Multiply formula for specific table

    Use
    =H$8*$G9

  3. #3
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Multiply formula for specific table

    Or use
    =IF(ROW(A1)=COLUMN(A1),H$8*$G9,"")
    in H9

  4. #4
    Registered User
    Join Date
    03-21-2015
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Windows 7
    Posts
    40

    Re: Multiply formula for specific table

    =H$8*$G9 It doesn work

  5. #5
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Multiply formula for specific table

    Hi
    see the file formula for multiply.xlsx

  6. #6
    Registered User
    Join Date
    03-21-2015
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Windows 7
    Posts
    40

    Re: Multiply formula for specific table

    Could we use the same multiply formula in H19 but without sum, and drag right to get the same value

  7. #7
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Multiply formula for specific table

    Yes, you can use in H22
    =OFFSET(G8,COLUMN(A1),1)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    see the file formula for multiply (1).xlsx
    Regards

  8. #8
    Registered User
    Join Date
    03-21-2015
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Windows 7
    Posts
    40

    Re: Multiply formula for specific table

    Perfect. Thank you for your patience, effort and help

+ 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] Multiply Value from the drop down to a specific cell
    By pphg in forum Excel General
    Replies: 6
    Last Post: 04-26-2017, 06:11 AM
  2. Multiply two cells if cell contains a specific word
    By rkobeyer in forum Excel General
    Replies: 1
    Last Post: 07-25-2014, 08:27 PM
  3. [SOLVED] remove specific text from certain cells, then multiply the numerical value left by 0.001
    By jeffnoone in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-21-2014, 02:25 PM
  4. [SOLVED] Find specific values and multiply them by a number in their column
    By Thomas92W in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-29-2014, 01:22 PM
  5. Formula for a cell contains a specific character then multiply by an another cell.
    By vinothkumarkv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 05:35 PM
  6. How to multiply specific values from two tables
    By ayresm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-13-2013, 05:07 PM
  7. Replies: 3
    Last Post: 02-01-2012, 04:21 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