Hi Garry,
Am Sat, 04 Jun 2016 03:31:12 -0400 schrieb GS:
IF(MOD(G3-28,28)=0,<then it's a multiple,<else it's not a
multiple)
Mod(0,28) is 0 too
Try:
=AND(G3<28,MOD(G3,28)=0)
Regards
Claus B.
OR?...
IF(G328,IF(MOD(G3,28)=0,<THEN,<ELSE),<ELSE?)
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus