formula to id a non-standard tick
 

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

formula to id a non-standard tick
 

=MOD(INT(A1*100),5)<0
--
Gary''s Student - gsnu200777


"carl" wrote:

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

formula to id a non-standard tick
 

Try:

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

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


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

formula to id a non-standard tick
 

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


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Try:

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

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


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