Cost Calculation Formula help

Hi Team,

i am trying to generate a cost calculation report for our network bandwidth utilization cost estimates and need help on excel formula.


Basically we are trying to perform the cost estimation for our bandwidth utilization.

Attached file provide the data and reference points

if 1GB is 0.087$ based on my utilization excel formulation as to calculate the cost estimation for me.

Tricky part is when it is cross 1000GB cost of the bandwidth reduces to 0.082$

so it has to calculate like upto 1000GB with the cost of 0.087 and after 1000GB crosses it has to calculate as 0.0.82$ for any 1 GB

hope i explained correctly, please excuse me if i didn't conveyed message correctly.

Thanks in advance for all your help.

Thank you all for your quick response.. this really helped and saved by time.. once again thank you quick response and showing me the way forward.