Thread: Need formula to test if cell is a multiple of 28, but not including 28
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Need formula to test if cell is a multiple of 28, but not including 28
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.
--
Windows10
Office 2016
Reply With QuoteReply With Quote