Thread: Division
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EK EK is offline
external usenet poster
 
Posts: 20
Default Division

I have a Col A of numbers. I want the result in Col B to return the value if
it can be fully divided by a certain number, e.g. 5, or else return a zero.
Does anybody know what should be the formula in Col B to get those results?

Col A Col B
------ ------
23 0
45 9
12 0
16 0
25 5