I am trying to create a solar calculator using the utility company's energy rates.
The utility company charges $0.05 for the first 400 kWh, plus
$0.09 for the next 400 kWh (401-800), plus
$0.11 for the next 2200 kWh (801-3000), plus
$0.12 for all additional kWh
How do I calibrate the "IF" function if the value falls between a range?
I have four columns on my excelsheet
One column for 0-400kWh
A second for 401-800kWh
A third for 801-3000kWh
and a fourth for 3001+
(note: I am using the following function for my first column "=IF(Y26>400, $F$8*400, $F$8*Y26)" (whereby Y26 is kWh usage and $F$8=rate)
I will add up the sum of the columns to get the total cost.
Please advise.
Bookmarks