I have a total of pounds sold, and 4 ranges to pick from if it equals the criteris. i.e., If the pounds are below 1 #, it equals 0, if lbs are between 2 #'s it equals 40, if lbs are between 2 other #'s it equals 150, and if lbs are greater than the highest #, it equals 200.
I've tried IF statements, and can get the first condition to work, however, when I add another, it errors with #value.
What formula do I need use?
Tags: