G
G Hunter
Here is a better way to say what I wanted --
What if a final number is let's say "56"? I would like this number to
trigger a dollar amount based on these range of numbers:
Group 1 Total Est. Hourly Usage (10-30 people) = $50
Group 2 Total Est. Hourly Usage (40-50 people) = $100
Group 3 Total Est. Hourly Usage (60-70 people) = $150
Group 4 Total Est. Hourly Usage (80-90 people) = $200
Group 5 Total Est. Hourly Usage (100-110 people) = $250
Group 6 Total Est. Hourly Usage (120+ people) = $300
So if my final number is a random number of "56 people" then how do I write
the formula to be able to work.
Because the number may change each month. One month it may be "26 people"?
So in words I would like to say:
"If field A1 is between 10 & 39 then put $50 in field A2.
If field A1 is between 40 & 59 then put $100 in field A2.
If field A1 is between 60 & 79 then put $150 in field A2.
If field A1 is between 80 & 99 then put $200 in field A2.
If field A1 is between 100 & 119 then put $250 in field A2.
If field A1 is 120 and above then put $300 in field A2.
I am self taught, so if I am saying this wrong, my apologies. But I think I
said it right. All in all, the total number needs to be able allow for any
number & give me a dollar amount.
Thanks for any assistance,
G. Hunter
(e-mail address removed)
What if a final number is let's say "56"? I would like this number to
trigger a dollar amount based on these range of numbers:
Group 1 Total Est. Hourly Usage (10-30 people) = $50
Group 2 Total Est. Hourly Usage (40-50 people) = $100
Group 3 Total Est. Hourly Usage (60-70 people) = $150
Group 4 Total Est. Hourly Usage (80-90 people) = $200
Group 5 Total Est. Hourly Usage (100-110 people) = $250
Group 6 Total Est. Hourly Usage (120+ people) = $300
So if my final number is a random number of "56 people" then how do I write
the formula to be able to work.
Because the number may change each month. One month it may be "26 people"?
So in words I would like to say:
"If field A1 is between 10 & 39 then put $50 in field A2.
If field A1 is between 40 & 59 then put $100 in field A2.
If field A1 is between 60 & 79 then put $150 in field A2.
If field A1 is between 80 & 99 then put $200 in field A2.
If field A1 is between 100 & 119 then put $250 in field A2.
If field A1 is 120 and above then put $300 in field A2.
I am self taught, so if I am saying this wrong, my apologies. But I think I
said it right. All in all, the total number needs to be able allow for any
number & give me a dollar amount.
Thanks for any assistance,
G. Hunter
(e-mail address removed)