specify a range of numbers in excel formula

Ron · Feb 12, 2004

How do I specify a range of numbers in excel formula I tried 12:56 but
since I am not specifing cells.

mudraker · Feb 12, 2004

=SUM(B1:B14)

or

=SUM(A1:B14)

or

=SUM(B1:B12,D1

12)

Vasant Nanavati · Feb 12, 2004

A little more detail would help. Why would you want a range of numbers in an
Excel formula?

Ron · Feb 12, 2004

Vasant Nanavati said:
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)

Vasant Nanavati · Feb 13, 2004

Can't do that. Try:

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

--

Vasant

Ron said:
"Vasant Nanavati" <vasantn *AT* aol *DOT* com> wrote in message

This is the actual formula I have been try to work

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