| 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","") |
| 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 | |||
Threaded Mode
