+ Reply to Thread
Results 1 to 2 of 2

Calculate formula based on multiple IFs

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    MS Office 2010
    Posts
    19

    Calculate formula based on multiple IFs

    Hello All!

    I am not sure what formulas I can use to figure this out. If the "Type" is equal to "Spread", I want sheet 3 to calculate the amount based on the percentage from sheet 2. What I am trying to accomplish is that I would get invoices for tools/parts but I want to "spread" them among all our properties based on their percentage of the total portfolio. i.e. if an invoice is $100, and I want to "Spread" this amount, I want to type the word "spread" in one column to signify to spread this across the board, and lets say building "AB" takes 50% of the total portfolio, I want to bill AB for $50. Any ideas on what formula to use would be great! It seems like I can maybe nest some VLOOKUP or IFS?

    Sheet 1:
    Type Amount
    Spread $100
    Spread $200

    Sheet 2:
    Building Percent
    AB 50%
    ML 25%

    Sheet 3 (Ideal Result)
    To Spread
    Building Amount
    AB $150 ($50+$100)
    ML $75 ($25+$50)

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Calculate formula based on multiple IFs

    Probably SUMIF would also be needed.

    soemthing like (sheet 3, cell B3)
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

+ 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. Replies: 1
    Last Post: 01-07-2018, 10:30 AM
  2. calculate a average based on multiple criteria
    By cnak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2016, 09:40 PM
  3. [SOLVED] Calculate SUM, based on multiple instances of a word
    By her.rockstar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 11:23 AM
  4. Calculate Based On Multiple Criteria
    By Kumara_faith in forum Excel General
    Replies: 5
    Last Post: 02-03-2012, 04:06 PM
  5. Calculate based on multiple criteria
    By day92 in forum Excel General
    Replies: 2
    Last Post: 03-10-2011, 08:11 PM
  6. Calculate Values based on Multiple Conditions
    By creativefusion in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-24-2009, 09:27 PM
  7. Replies: 8
    Last Post: 03-21-2008, 12:09 PM

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