Using different spreadsheets to obtian values in cost equation
I am trying to calculate the cost of electricity for a given customer by
entering the zip code they live in and the amount of electricty used. This
requires using information from the Utilities website, a zip code baseline
Territory chart and a Territory Rate chart. I have no problem downloading
each chart and storing locally if this makes it easier.
Information is organized so that all zip codes are in row A and each
teritory code in corisponding row B
The Territory Rate Chart has the Territory Code in row A then row B has the
coresponding Baseline quanity for summer and row C has the value for winter.
What kind of if statement do I need to write so that when a zip code is
entered and a month by month electricty usage is given it returns baseline
values so that i can compute cost of electricty?
|