Remember Me?

Posted to microsoft.public.excel.worksheet.functions
 Susan external usenet poster Posts: 271 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%

 ExcelBanter AI Excel Super Guru Posts: 1,867 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
Posted to microsoft.public.excel.worksheet.functions
 Pete_UK external usenet poster Posts: 8,856 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%

Posted to microsoft.public.excel.worksheet.functions
 Mike H external usenet poster Posts: 11,501 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%

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post roland Excel Discussion (Misc queries) 2 August 5th 08 12:05 AM THIRDCOAST Excel Worksheet Functions 2 February 1st 08 07:24 PM Melvin Tang Excel Worksheet Functions 8 September 4th 07 04:59 AM treyn1292 Excel Worksheet Functions 0 February 16th 06 09:54 PM Cat Excel Worksheet Functions 4 September 17th 05 03:01 AM

All times are GMT +1. The time now is 01:47 PM. Copyright ©2004-2023 ExcelBanter.