Thread: Error in my formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Error in my formula?
Would this do it for you? It's slightly more intuitive, for not having
the INT and MOD functions.
=(IF(E10<1.1,0,4+((E10*100)-110)*0.25))

Reply With QuoteReply With Quote