| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create helper column which returns a text string based on multiplecriteria. | Excel Worksheet Functions | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| Can I insert 'carriage/line returns' in text string? | Excel Worksheet Functions | |||
| Help formula that returns a text string from another sheet | Excel Worksheet Functions | |||
| use concatenate function to put carrage returns in a text string | Excel Worksheet Functions | |||
Hybrid Mode
