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

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

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

How do I return a text string when a calculation returns a non who
 

=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

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

How do I return a text string when a calculation returns a non
 

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

How do I return a text string when a calculation returns a non
 

Thanks Pete.

I entered
=IF(INT(E11/F11)=E11/F11,"","You must order in case quantities")
and if the number is a whole number, it still returns the string "You must
order...."

Thanks,
Becki

"Pete_UK" wrote:

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

How do I return a text string when a calculation returns a non
 

Well, I just copied your formula directly from your posting into cell
G11 of a blank sheet, put some numbers in E11 and F11, and it worked
fine for me.

Pete

On Aug 6, 5:32*pm, bcronin wrote:
Thanks Pete.

I entered
=IF(INT(E11/F11)=E11/F11,"","You must order in case quantities")
and if the number is a whole number, it still returns the string "You must
order...."

Thanks,
Becki



"Pete_UK" wrote:
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- Hide quoted text -

- Show quoted text -

How do I return a text string when a calculation returns a non
 

It should be B1/A1...

=IF(MOD(B1/A1,1),"You must order in case quantities","Quantity Correct")

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


"bcronin" wrote:

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

How do I return a text string when a calculation returns a non
 

Thanks Jacob! This worked perfectly!

Cheers - and thanks all for the help!

"Jacob Skaria" wrote:

It should be B1/A1...

=IF(MOD(B1/A1,1),"You must order in case quantities","Quantity Correct")

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


"bcronin" wrote:

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