Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 271
Default if cell falls within range of number (i.e. 2500 to 4999)

I want to detetermine is a cell falls within a pre-estabished set up ranges.

Cell A1 = 4800
Such as
if quantity is 2500-4999 it should return 1.5%
if quantity is 5000-9999 it should return 1.2%

So this correct answer should return 1.5%


  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: if cell falls within range of number (i.e. 2500 to 4999)

  1. Open the Excel worksheet and select the cell where you want to display the percentage.
  2. Type the following formula into the cell:

    Formula:
    =IF(AND(A1=2500,A1<=4999),[b]1.5%[/b],IF(AND(A1=5000,A1<=9999),[b]1.2%[/b],"")) 
  3. In this formula, we are using the IF function to check if the value in cell A1 falls within the range of 2500 to 4999. If it does, the formula returns 1.5%. If not, it checks if the value falls within the range of 5000 to 9999. If it does, the formula returns 1.2%. If the value in cell A1 does not fall within either of these ranges, the formula returns an empty string ("").
  4. Press Enter to apply the formula to the cell.
  5. The cell should now display the corresponding percentage based on the value in cell A1. In this case, since the value in cell A1 is 4800, the formula returns 1.5%.

That's it! You can now use this formula to determine the percentage for any value that falls within your pre-established set of ranges.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default if cell falls within range of number (i.e. 2500 to 4999)

What do you want to happen if the value in A1 is less than 2500 or
greater than 9999?

Pete

On Aug 18, 5:17*pm, Susan wrote:
I want to detetermine is a cell falls within a pre-estabished set up ranges.

Cell A1 = 4800
Such as
if quantity is 2500-4999 it should return 1.5%
if quantity is 5000-9999 it should return 1.2%

So this correct answer should return 1.5%


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default if cell falls within range of number (i.e. 2500 to 4999)

Susan,

Format the cell with this in as percentage

=IF(AND(A1=2500,A1<=4999),1.5%,IF(AND(A1=5000,A1 <=9999),1.2%,"Outside of
range"))

Mike

"Susan" wrote:

I want to detetermine is a cell falls within a pre-estabished set up ranges.

Cell A1 = 4800
Such as
if quantity is 2500-4999 it should return 1.5%
if quantity is 5000-9999 it should return 1.2%

So this correct answer should return 1.5%


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNT IF A VALUE FALLS WITHIN A RANGE IN A SINGLE CELL roland Excel Discussion (Misc queries) 2 August 5th 08 12:05 AM
displaying text in a cell if a another cell falls in a range THIRDCOAST Excel Worksheet Functions 2 February 1st 08 07:24 PM
IF CELL VALUE FALLS WITHIN A RANGE OF VALUES Melvin Tang Excel Worksheet Functions 8 September 4th 07 04:59 AM
update cell only if now() falls in a given date range treyn1292 Excel Worksheet Functions 0 February 16th 06 09:54 PM
Formula to determine whether number falls within range?? Cat Excel Worksheet Functions 4 September 17th 05 03:01 AM


All times are GMT +1. The time now is 01:47 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"