LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,080
Default specify a range of numbers in excel formula

Can't do that. Try:

=IF(AND(C65=2501,C65<=5000),0.02441,0)

--

Vasant


"Ron" wrote in message
om...
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message

...
A little more detail would help. Why would you want a range of numbers

in an
Excel formula?


This is the actual formula I have been try to work

=IF(C65=2501:5000,0.02441,0)


 
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
Which formula to bucket range of numbers marq New Users to Excel 6 May 7th 23 03:44 AM
excel: How to set up a formula for a range of numbers ie. 3.5-5.. LadyK974 Excel Worksheet Functions 3 April 27th 10 06:31 AM
formula to select numbers from a range mark (plymouth) Excel Worksheet Functions 1 February 14th 06 05:09 PM
Range of numbers in a formula...PLEASE HELP!!! jbf frylock Excel Worksheet Functions 9 January 6th 06 03:50 PM
Trying to enter a range of numbers using >1 and < 5 in a formula Mel9970 Excel Worksheet Functions 1 March 29th 05 08:52 PM


All times are GMT +1. The time now is 03:00 AM.

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

About Us

"It's about Microsoft Excel"