Hi i am trying to work out a formula that will allow me to get an answer dependant on certain criteria
e.g. if the sum of a cell is more than 0 but less than 300 will answer 40, more than 301 but less than 400 will answer 30, and more than 401 but less than 500 will give 20
Any ideas??
Bookmarks