Thread: formula to id a non-standard tick
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
  
Posts: 361
Default 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
Reply With QuoteReply With Quote