=IF(AND(D10B20,D10<B20+1)<B10,B20)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ERG" wrote in message
...
How do you make a formula to state if a number is greater than one number
but
less than another number. My example is: if d10 is greater than b20 but
less
than b20+1, then b10, if not, b20.