View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default Check if Equally Divisible

=IF(MOD(A1,B1)=0,"Yes","No")

--
Kind regards,

Niek Otten

"John" wrote in message ...
I want to check if a value is equally divisible by another value and not sure how to do it

Say I have 6600 in A1 and 250 in B1, what formula could I use to return the value "No" in C1