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'
|