formula to id a non-standard tick

[carl]

my prices look like this

0.65
0.63
0.60

I need a formula that willl return true if the last digit is not a 5 or 0.
Something like this:

False
True
False

 

[Gary''s Student]

=MOD(INT(A1*100),5)<>0

 

[Sandy Mann]

Try:

=ROUND(MOD(A1,0.05),14)=0

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

It was only when I saw Gary"s Student's post I realised that had misread
your post:

=ROUND(MOD(A1,0.05),14)<>0

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk