Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Modify a formula
This is showing how much of a novice I am, but I'm learning. I need to
change this formula so that it not only shows the message if multiples of 84 is not entered but if multiples of 61 is not entered into the same cell. Thanks. =IF(MOD(F21,84)<0,"Qty in this Row is not in multiples of 84","") |
#2
|
|||
|
|||
Hi!
Try this: =IF(MOD(F21,84)=0,"",IF(MOD(F21,61)=0,"","Qty in this Row is not in multiples of 84 or 61")) Biff "Eintsein_mc2" wrote in message ups.com... This is showing how much of a novice I am, but I'm learning. I need to change this formula so that it not only shows the message if multiples of 84 is not entered but if multiples of 61 is not entered into the same cell. Thanks. =IF(MOD(F21,84)<0,"Qty in this Row is not in multiples of 84","") |
#3
|
|||
|
|||
Another option:
=LCM(61,84) 5124 then... =IF(MOD(A1,5124)=0,"","Qty not mul of 61 or 84") HTH -- Dana DeLouis Win XP & Office 2003 "Eintsein_mc2" wrote in message ups.com... This is showing how much of a novice I am, but I'm learning. I need to change this formula so that it not only shows the message if multiples of 84 is not entered but if multiples of 61 is not entered into the same cell. Thanks. =IF(MOD(F21,84)<0,"Qty in this Row is not in multiples of 84","") |
#4
|
|||
|
|||
Thanks Guys. Works perfect. I don't know what I would do with out
people like you helping me, Thanks again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modify a Formula to Display Blank | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |