Tariff Calulation

[fabian24]

I want to make use of a if statement to incorporate the following rate...

if Consumption > 6001 then Tariff = kwh *.33
if Consumption > 4001 and < 6000 the Tariff = kwh*.28
if Consumption > 2001 and < 4000 the Tariff = kwh*.24
if Consumption > 2000 the Tariff = kwh*.28

Could you please help me write the statement.

[shg]

=index({0.28,0.24,0.28,0.33}, match(a1, {0,2000,4000,6000}) ) * a1

[fabian24]

Thankyou very much

[shg]

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes