I need to extract the price if the #subscribers is within range c-d
Subscriber change (increase every month) price depends on a number of subscribers
#subscribers is in row A from columns 1 to 60
if(#subscribers) is within range C-D then E
C D E
low range max range price
1,001.00 1,500.00 $20.00
1,501.00 2,000.00 $25.00
2,001.00 2,500.00 $30.00
2,501.00 2,600.00 $35.00
so for example, if the # of subscribers is 1,657 I need the formula to return $25.00
so for example, if the # of subscribers is 2,407 I need the formula to return $30.00
=======
This will also apply to another similar situation where the bandwidth price changes with the amount of traffic
Bookmarks