If the decimal value is a multiple of 0.25, then the remainder of dividing
the decimal value by 0.25 is zero. This formula does just that and returns
"Yes" if it is a divisor, otherwise "No".
=IF(MOD(A1,0.25)=0,"Yes","No")

HTH Otto

"crapit" wrote in message
...
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