| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula to test if cell is a multiple of 28, but not including 28
I have successfully used =IF(MOD(G3,28)=0 to identify whether my cell value is a multiple of 28, but I need for it to exclude 28 itself. The very simple formula that I use thereafter =(E7/28)*$G$3 works fine. I've tried all kinds of nested if statements and I can't seem to find a solution here. Any help much appreciated. Waz' |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula not including a cell | Excel Worksheet Functions | |||
| Cell including text and multiple formulas? | Excel Discussion (Misc queries) | |||
| How do I select numbers for a formula from a cell including text? | Excel Discussion (Misc queries) | |||
| Link to Multiple Cells Within One Cell Including Text | Excel Programming | |||
| Including a range of number in a IF (Logical Test) formula | Excel Worksheet Functions | |||
Threaded Mode
