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.

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/

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.

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)

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)