On Friday, 3 June 2016 15:59:00 UTC-6, Wazzel wrote:
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'

Thanks so very much! It worked perfectly.