I have a formula that I am using IF(K4=”1-90″,N4*50,If(K4=”1-100″,N4*32,IF(K4=”1-250″,N4*14.57,))) Excel keeps telling me that there is a problem with this formula even though it works and does what I want. it wants to format 1-90 as a date can’t figure out how to stop this.