Thread: How do I return a text string when a calculation returns a non who
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default How do I return a text string when a calculation returns a nonwho
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

Reply With QuoteReply With Quote