Thread: Any number above 15 returns false when it should be true
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tlaurie777 tlaurie777 is offline
external usenet poster
  
Posts: 1
Default Any number above 15 returns false when it should be true
=IF((16.99-16)=0.99,10,0)

In this function, any number from (1.99-1) through (15.99-15) works and any
number above (16.99-16) fails.
Reply With QuoteReply With Quote