=IF(AND(F13=25%,F13<=75%),"yes","no")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"las" wrote in message
...
how do I use a % range for instance if f13 is 25-75% in a formula