Results 1 to 3 of 3

Formula for excel to identify number ranging 1-10, 11-20 etc inserting 1-10 = £1

Threaded View

RayBell Formula for excel to identify... 01-04-2018, 06:50 AM
AliGW Re: Formula for excel to... 01-04-2018, 06:55 AM
MrShorty Re: Formula for excel to... 01-04-2018, 09:40 AM
  1. 01-04-2018, 06:50 AM #1
    RayBell is offline
    Registered User
    Join Date
    01-04-2018
    Location
    Scotland
    MS-Off Ver
    2013
    Posts
    1

    Formula for excel to identify number ranging 1-10, 11-20 etc inserting 1-10 = £1

    Hi,

    I have a excel book with details on sheet 1 looking to identify from a range of numbers on sheet 2 which will give a value on sheet 2.

    Sheet 1
    B3 = 5

    Sheet 2
    A20 0-10 = £1
    A2211-20 = £2
    A22 21-30 = £3

    I'd like Sheet 2 cell C5 to pick that 5 is within A20 and should show £1 etc.

    Any help?

    Thanks

    Ray
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. formula to identify week number based on date ranges and add values
    By Lmendez in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-18-2014, 12:55 PM
  2. [SOLVED] Formula to identify a unique number and its most recent date
    By Excel Analyst in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-15-2013, 04:51 PM
  3. [SOLVED] Excel Formula to identify each number change in a column
    By mcranda in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2012, 12:37 PM
  4. [SOLVED] Formula needed to identify number within a range of numbers
    By easglos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2012, 09:26 AM
  5. Excel 2007 : A formula to identify whether a number is odd or even?
    By The_Snook in forum Excel General
    Replies: 3
    Last Post: 07-18-2012, 10:07 AM
  6. Require formula to identify a number, not text
    By Fbs1960 in forum Excel General
    Replies: 3
    Last Post: 12-17-2011, 06:55 AM
  7. Identify Formula vs Number
    By DCSwearingen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2007, 02:20 PM
  8. Formula to Identify Column Number
    By Michael Link in forum Excel General
    Replies: 4
    Last Post: 08-14-2005, 11:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1