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