Thread: How do I return a text string when a calculation returns a non who
View Single Post
  #5   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
Thanks! This returns a "1" when the amount is a whole number. How would I
modify it to return "Quantity Correct"?

Becki

"Teethless mama" wrote:

=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