Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |||
Getting wrong values | Excel Worksheet Functions | |||
Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Incorrect SUM Values in Excel Spreadsheets | Excel Worksheet Functions |