+ Reply to Thread
Results 1 to 4 of 4

Needing help with IF, AND Function?

  1. #1
    Registered User
    Join Date
    09-01-2011
    Location
    Central USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Question Needing help with IF, AND Function?

    I am trying to use multiple formulas to come to a final outcome. The final formula is fighting back.

    In words:
    if g7 is >0 and <=30... i7 will be the number 1000
    if g7 is >30 and <=60... i7 will be the number 1900
    if g7 is >60 and <=90... i7 will be the number 2900
    if g7 is >90 and <=120... i7 will be the number 3900
    if g7 is >120 and <=150... i7 will be the number 4900
    if g7 is >150 and <=180... i7 will be the number 5900
    if g7 is >180 and <=210... i7 will be the number 6900
    if g7 is >210 and <=240... i7 will be the number 7900
    if g7 is >240 and <=270... i7 will be the number 8900
    if g7 is >270 and <=300... i7 will be the number 9900

    When I try and put all this into one formula, I seem to have an error somewhere. Do I need to use another type of functions? Please help.
    Last edited by jbolinger; 09-01-2011 at 11:57 AM. Reason: ask for other functions to use
    Thank you for your time,

    Jimmy Bolinger

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Needing help with IF, AND Function?

    Will this work?

    =IF(G7<=30,1000,INT((G7-1)/30)*1000+900)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Needing help with IF, AND Function?

    Try

    =IF(G7<=0,"",INDEX({990,8900,7900,6900,5900,4900,,3900,2900,1900,1000},match(g7,{300,270,240,210,180,1560,120,90,60,30},-1))

  4. #4
    Registered User
    Join Date
    09-01-2011
    Location
    Central USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Needing help with IF, AND Function?

    Worked Great!

+ 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