+ Reply to Thread
Results 1 to 5 of 5

IF formula for mulitple conditions and multiple outcomes

  1. #1
    Registered User
    Join Date
    12-05-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    4

    IF formula for mulitple conditions and multiple outcomes

    Hi,

    Hoping someone out there can help. This is my first post so i hope i get it right with what i am trying to say and effectively do...

    I am complying an order form for shoes. There are multiple colours per style that you can order. i am trying to introduce an incentive for the less popular colours where if you select these particlar colours, you will receive 3% off the total price of that style; but only if you include these colours, if not, then the price remains as normal.

    i have attached an example of the order form... There is a summary page where everything is tallied and the total amounts shown, and the order page. The highlighted yellow cells on the order page are the incentive colours, and if you select sizes of these colours you will get the discount. (this crosses over all months)

    I hope i am making sense. This formula is way above my knowledge of excel and so i have no idea what kind of formula i am even needing.

    Basically what i think i need the formula to say is:

    =IF(G28,H28,I28,G28,K28,L28>=1, and
    =IF(G44,H44,I44,G44,K44,L44>=1, then apply the 3% dicount to total style
    =Summary!M19/.03

    All of these cells alreadu have formulas in, so not sure if that is an issue. let me know if you need more information

    Can someone please help?
    Attached Files Attached Files
    Last edited by kazthomas; 12-06-2012 at 08:33 PM.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: IF formula for mulitple conditions and multiple outcomes

    without looking the file, based on the options you've given

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: IF formula for mulitple conditions and multiple outcomes

    Quote Originally Posted by vlady View Post
    without looking the file, based on the options you've given

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    OP is not dealing with the negative numbers, you can shorten up your formula


    =IF(AND(SUM(G28:L28),SUM(G44:L44)),Summary!M19/0.03," No Discount")

  4. #4
    Registered User
    Join Date
    12-05-2012
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: IF formula for mulitple conditions and multiple outcomes

    Thank you both!! that seems to work well.


  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: IF formula for mulitple conditions and multiple outcomes

    Your welcome.
    Can you mark this thread "solved"

    How?
    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

    Note:
    You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
    By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.

+ 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