Need an excel formula made that will take the kilowatt value generated from the dollar amount and, in 4 different cells on the table –organized in a vertical column– generate numbers from doing the following to the kilowatts in this order:
1) multiply kilowatts by 12
2) divide result by 1.8 and round the the nearest hundredth decimal point
3) divide result by 327 and round the nearest whole number
4) multiply result by 5.5