View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
DriverDB DriverDB is offline
external usenet poster
 
Posts: 2
Default How to find multiple of a value?

Just for fun, because I haven't thought it through...

=IF(A1*4=INT(A1*4),"Yes","No")

"crapit" wrote in
:

How do I use formula to check whether the decimal value is a mutiple of
0.25?

E.g 5.25, 18.50, 1.75 decimal value are multiple of 0.25