formula to id a non-standard tick

  • Thread starter Thread starter carl
  • Start date Start date
C

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
 
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
 
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
 
Back
Top