+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Difficult Formula Question

  1. #1
    Registered User
    Join Date
    03-07-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Question Difficult Formula Question

    I'm trying to create a conditional formula in Excel 2007 to calculate a dollar amount, based on a set of tiered numbers.
    IF D2= any number 1 through 10, multiply it by 50
    IF D2= any number between 11 through 14, multiply by 75
    IF D2= any number greater than 15, multiply by 100

    Here's what I have, but this isn't working - it keeps saying TRUE when I enter in numbers into D2.

    =IF(D2<11,D2*50)=AND(D2>10,D2<15,D2*75)=AND(D2>14,D2*100)

    Any help would be appreciated!

    Thanks!
    Lauren

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Difficult Formula Question

    Hello Lauren, try like this

    =IF(D2<=10,50,IF(D2<=14,75,100))*D2
    Audere est facere

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Difficult Formula Question

    Maybe =D2*LOOKUP(D2, {1,11,15},{50,75,100})
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    03-07-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Difficult Formula Question

    That worked perfect DaddyLongLegs!
    Thank you !!!!!!!!!!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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