Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
Creating lookup formulas for material cost spreadsheet | Excel Worksheet Functions | |||
Help creating a cost range | Excel Discussion (Misc queries) | |||
Indexing a row | Excel Worksheet Functions |