+ Reply to Thread
Results 1 to 2 of 2

Combining If & And functions

  1. #1
    Registered User
    Join Date
    09-27-2010
    Location
    Brownsville, TX
    MS-Off Ver
    Excel 2007
    Posts
    1

    Red face Combining If & And functions

    Hello, I need help on the following:

    I attached the file "assign 1" because I am having trouble setting the formulas for the following criterias...
    Welcome & Thanks 30%off: This reward is given to customers who spent $0 last year and the number of years purchasing is less than one.
    Please come back 50%off: This reward is given to customers who have been purchasing from the store for more than one year but have not made a purchase in the past 12 months
    Thanks for being loyal25%off: This reward is givn to customers who have been making purchases for more than two years or spent more than $1,000 last year
    Customer Appreciation 10%off: this reward is given to any customer who does not meet the criteria of the other three rewards.

    I am lost, please help me!
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: Combining If & And functions

    Hi,

    In E3

    =IF(AND(B3<1,C3=0),"Welcome & Thanks 30%off",IF(AND(B3>1,C3=0),"Please come back 50%off",IF(OR(B3>2,C3>1000),"Thanks for being loyal25%off","Customer Appreciation 10%off")))
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ 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