I am having problems writing a formula that will return a different number based on were a number falls in different ranges. Below is an example<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
499 500 400<o></o>
399 300<o></o>
299 200<o></o>
199 100<o></o>
<o> </o>
If the number in the first column fall in range one then 3, if range second range then 2, if the third range then 1. Any ideas?<o></o>
<o> </o>
499 500 400<o></o>
399 300<o></o>
299 200<o></o>
199 100<o></o>
<o> </o>
If the number in the first column fall in range one then 3, if range second range then 2, if the third range then 1. Any ideas?<o></o>