+ Reply to Thread
Results 1 to 4 of 4

Multiply Column

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    NL
    MS-Off Ver
    2011 MAC
    Posts
    2

    Angry Multiply Column

    I am having trouble with the final formula for this spreadsheet.

    I want to be able to select "Holiday/Sunday" from the drop down men in column H, and have it multiply the total in column F by 2. There is already a formula in column F that sums column E-D.

    How do I do this?
    Attached Images Attached Images

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Multiply Column

    Pictures are pretty useless to work with. I can't see what your existing formulae are. In future, attach a workbook.

    Try something like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Multiply Column

    it is difficult to discern what you want and where from screen shots, however, if you want it in the formula in col F you could write it as
    =IF(H7="Sunday/holiday",(E7-D7)*2,E7-D7).
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    07-30-2014
    Location
    NL
    MS-Off Ver
    2011 MAC
    Posts
    2

    Re: Multiply Column

    Sorry for not posting an excel file (I instantly regretted it)

    You guys are wizards! Thank you both so much!

    :D

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Multiply Column

    good, glad to have helped. And since you're new to the forum, you can thank any and all who helped you by clicking on "* add reputation" as that is how we advance on this forum.
    BTW, the forum moderators like it if you mark your post as solved by using the thread tools dropdown at the top of this post (if you haven't already).

+ 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. Looking to Multiply the next value in a column
    By NOGRANMA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2014, 07:15 AM
  2. how to multiply row and column
    By dinatamrakar in forum Excel General
    Replies: 1
    Last Post: 09-20-2013, 08:52 AM
  3. Replies: 1
    Last Post: 07-12-2012, 02:29 PM
  4. multiply column
    By jokerboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2011, 11:04 AM
  5. Replies: 8
    Last Post: 08-06-2009, 09:02 AM

Tags for this Thread

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