specify a range of numbers in excel formula

[Ron]

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

 

[mudraker]

=SUM(B1:B14)

or

=SUM(A1:B14)

or

=SUM(B1:B12,D112)

 

[Vasant Nanavati]

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

 

[Ron]

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]

Can't do that. Try:

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

--

Vasant

"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)