Please Help with formula usage per month use if statements in one formula?

[rmschott]

Kolum Tariff group NAF/kWh
A ≤ 250 0.4761 cents
B >250 ≤ 350 0.5824 cents
C >350 0.6266 cents

I have 3 tariff groups like above.

If the usage for example = 240 till or equals 250 = 240 x 0.4761

If >250 ≤ 350

[63falcondude]

Hello and welcome to the forum.

Assuming that the usage is in cell A2, try this:

=LOOKUP(A2,{0,251,351},{0.4761,0.5824,0.6266})

[rmschott]

Thank you for your quick response,

I will try your method first, looks more simple

I tried this with the if statement
=IF(C4<=250,(C4*$F$2),IF(C4>250,<=350,(C4*$G$2),IF(C4>350,(C4*$H$2)))

Thank you i will come back

[63falcondude]

The only issue with the formula in post #2 is that it assumes that the usage will always be an integer.

If it is possible for the usage to be, say 250.1, the formula in post #2 would result in 0.4761 when the expected result is 0.5824.

You could change the values in the first array to something like {0,250.0001,350.0001} but then if there can be a usage of 250.00001 (for example), the formula would return an unexpected result.

The most foolproof way would probably be through a nested IF formula like this:

=IF(A2>350,0.6266,IF(A2>250,0.5824,0.4761))