+ Reply to Thread
Results 1 to 3 of 3

Formula to return a number of days from an amount enter on spreadsheet

Hybrid View

  1. #1
    Registered User
    Join Date
    11-15-2009
    Location
    Chesterfield, Derbyshire
    MS-Off Ver
    Excel 2003
    Posts
    1

    Formula to return a number of days from an amount enter on spreadsheet

    Please help, this is quite urgent and just cant seem to figure it out.

    I need the number of Days returning when i enter in an amount for example

    £1500 = 5 Days.

    The full list is below

    £1-£1000 = 3 Days
    £1001-£2500 = 5 Days
    £2501-£5000 = 10 Days
    £5001-£9999 = 20 Days
    £10,000 + = 30 Days

    I managed to get so far with the following formula but something is wrong with it and now im stuck.

    =IF(A2>10000,"30 Days",IF(A2>5000,"20 Days",IF(A2>2500,"10 Days",IF(A2>1000,"5 Days",A2>1"3 Days"))))

    Please help thanks

    Lee
    Last edited by leebexton; 11-15-2009 at 03:30 PM. Reason: add more detail to post description

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,043

    Re: excel formula help urgent!!!

    Wellcome to the forum. Please, rename your thread according to the rules.

    (Rule 1)

    Hint: make your title better decribe your problem.
    Never use Merged Cells in Excel

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,043

    Re: Formula to return a number of days from an amount enter on spreadsheet

    Here, try this: =LOOKUP(A2,{1,1001,2501,5001,10000},{3,5,10,20,30})

+ 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