+ Reply to Thread
Results 1 to 4 of 4

If statement - unable to work out why it doesn't work

  1. #1
    Registered User
    Join Date
    08-31-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    21

    If statement - unable to work out why it doesn't work

    This is probably an easy problem but I can't get my head around why it's not working. I am normally good with this but somehow my logic is not working.

    Spreadsheet is attached.

    What has gone wrong?
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,282

    Re: If statement - unable to work out why it doesn't work

    In what way do you think it's wrong?
    Rory

  3. #3
    Registered User
    Join Date
    08-31-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    21

    Re: If statement - unable to work out why it doesn't work

    sorry. when I changed the threshold to 4,000,000,001 it defaults to 2.5bps but it's suppose to be 3 and if I changed to 2,000,000,000 it defaults to 3 and not 3.5

    so i think it's to do with my formula

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: If statement - unable to work out why it doesn't work

    The way you have it set up you need to change the threshold in the table AND the formula.
    Do it this way below and you only need to change the value in the table.


    Split column L into two columns, put the lower values in column L (e.g. 0 and 1000000001 etc) and the higher values (1000000000 and 2000000000 etc) in column M.
    Your table is now in L8:N11

    Now change the formula in column F to

    =VLOOKUP(E14,L$8:N$11,3,1)

    Values from your original formula look ok to me (I only had a quick glance).
    Last edited by Special-K; 11-25-2019 at 09:28 AM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Unable to get an If statement to work correctly
    By kcgojnur in forum Excel General
    Replies: 3
    Last Post: 09-28-2016, 09:46 AM
  2. IF statement doesn't work as expected
    By ilao in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-19-2015, 12:58 PM
  3. [SOLVED] Unable to get if statement to work
    By fialko in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2011, 03:47 AM
  4. Why doesn't this IF statement Work
    By maurices5000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2008, 01:38 PM
  5. If statement doesn't work for range?
    By deeppurple247 in forum Excel General
    Replies: 4
    Last Post: 02-07-2007, 07:55 PM
  6. My ChDir Statement doesn't work
    By emil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2006, 03:00 PM
  7. [SOLVED] Why doesn't this nested IF statement work?
    By Brandoni in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2006, 05:30 PM

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