Can someone help me with this:
My electric company charges .08 a kwh up to 1000 kwh, .10 a kwh above 1000 kwh. how do I use min and max do calculate this, so that in one cell has the value to 1000 kwh and another has the value above 100 kwh? John