View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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?