Hi all,
I have a questions on picking out the right price for the quantity ordered. I doubt the function "if" can handle that many tiers of separation. How would you suggest me to fix this? How would "Choose" fix this?
Quantity Price/Unit
1-50 $100
51-110 $98
111-240 $95
241-295 $91
296-375 $86
376-550 $80
551-625 $73
626-745 $65
746-815 $56
816+ $50
If a person enters say, 300 units, the next cell would return "$86".
Thanks.
Fred
I have a questions on picking out the right price for the quantity ordered. I doubt the function "if" can handle that many tiers of separation. How would you suggest me to fix this? How would "Choose" fix this?
Quantity Price/Unit
1-50 $100
51-110 $98
111-240 $95
241-295 $91
296-375 $86
376-550 $80
551-625 $73
626-745 $65
746-815 $56
816+ $50
If a person enters say, 300 units, the next cell would return "$86".
Thanks.
Fred