total amount based on selections of 1-9, 10-19 and 20-30
Thank you for your response. I will try it out and get back with you.
"JE McGimpsey" wrote:
One way (though your problem statement is rather vague):
=CHOOSE(INT(A1/10)+1,"Total 1", "Total 2", "Total 3", "Total 3")
(the last "Total 3" is necessary since your third range is bigger than
the first two).
In article ,
Pete Elbert wrote:
I am trying to calculate a total based on the number of items a person
purchases that fall within one of these three amounts (1-9,10-19,20-30). Can
anyone help
|