Thanks a Lot, I did a mix of If(and(

It worked!

JP

"Ron Rosenfeld" wrote:

On Thu, 19 Apr 2007 08:26:00 -0700, juanpablo
wrote:

Hi,

If I have a number X and I want to apply and IF the number X 1000 and <
2000,

How do I implement that in the formula
Because IF(X1000<2000;"") wont work,

help please

=IF(AND(X1000,X<2000);...)
--ron