Thanks Jacob. I entered
=IF(E10/F10<INT(E10/F10),"You must order in case quantities",E10/F10)

and if the number is whole, I still get the "You must order in case
quantities"
Thanks,
Becki

"Jacob Skaria" wrote:

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

If this post helps click Yes
---------------
Jacob Skaria


"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