Thread: getting numbers that are divisible by 4
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jovan Timotijevic[_2_] Jovan Timotijevic[_2_] is offline
external usenet poster
  
Posts: 12
Default getting numbers that are divisible by 4

Enter this formula in B1 and double click on fill handler to copy it 10000
rows below.

=IF(MOD(A1,4)=0,A1,"")
Reply With QuoteReply With Quote