I am trying to write a formula that essentially says the following but I am struggling.
Cell A2 = 0 if A1 = less than 20000, 200 if Cell A1 = between 20000 & 24999.99, 300 if Cell A1 = between 25000 & 29999.99, 500 if A1 = 30000 & Over
Can a guru write it for me?
Bookmarks