aries wrote...
how do i use between instead of greater than or less than , in if then else
statement

Excel lacks SQL's BETWEEN operator, but if you really can't use < or
for whatever reason, you could try something like

="x "&IF(MEDIAN(x,a,b)=x,"","not ")&"between a and b"