| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
specify a range of numbers in excel formula
How do I specify a range of numbers in excel formula I tried 12:56 but
since I am not specifing cells. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
specify a range of numbers in excel formula
=SUM(B1:B14)
or =SUM(A1:B14) or =SUM(B1:B12,D1:D12) --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
specify a range of numbers in excel formula
A little more detail would help. Why would you want a range of numbers in an
Excel formula? -- Vasant "Ron" wrote in message om... How do I specify a range of numbers in excel formula I tried 12:56 but since I am not specifing cells. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
specify a range of numbers in excel formula
"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) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which formula to bucket range of numbers | New Users to Excel | |||
| excel: How to set up a formula for a range of numbers ie. 3.5-5.. | Excel Worksheet Functions | |||
| formula to select numbers from a range | Excel Worksheet Functions | |||
| Range of numbers in a formula...PLEASE HELP!!! | Excel Worksheet Functions | |||
| Trying to enter a range of numbers using >1 and < 5 in a formula | Excel Worksheet Functions | |||
![Ron[_17_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
