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
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How do I return a text string when a calculation returns a non who
=IF(MOD(A1/B1,1),"You must order in case quantities",A1/B1)


"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