Thanks Pete.

I entered
=IF(INT(E11/F11)=E11/F11,"","You must order in case quantities")
and if the number is a whole number, it still returns the string "You must
order...."

Thanks,
Becki

"Pete_UK" wrote:

Try this:

=IF(INT(A1/B1)=A1/B1,"","You must order in case quantities")

Hope this helps.

Pete

On Aug 6, 3:59 pm, bcronin wrote:
I need to display text "You must order in case quantities" when

A1/B1 does not equal a whole number (A1 being case quantities and B1 being
quantity ordered)

I'm pulling my hair out and it's probably really simple.... sigh.

Thanks for any help!
Becki