IF function between a range of numbers e.g 1000 to 2000
hi,
=AND(a1=1000,a1<=2000)
result either true or false
maybe..
"suz" wrote:
I want to check if a number is ina range between 1000 and 2000 and I can't
get the IF function to work propoerly using the greater than and smaller than
signs
|