I need help with an excel equation that will be going on my site. It should be pretty simple but for some damn reason i can't get it to work. What i need to do is have cell B1 calculate a number based upon cell A1. If A1 is between the numbers 10.00 and 19.99 it should display 50, if A1 is between the numbers 20.00 and 29.99 is should display 100, if A1 is between the numbers 30.00 and 99.99 is should display 200 This is so far what i have gotten but it simply won't calculate. =IF(A1="10-19.99",50,IF(A1="20.00-29.99",100,IF(A1="30.00-99.99",200,0))) ughhh i hate spreadsheets and i need your help guys Thanks!