LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default Creating a Utility Cost calculator

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Creating lookup formulas for material cost spreadsheet mn_tater Excel Worksheet Functions 5 December 15th 05 09:46 PM
Help creating a cost range tysonstone Excel Discussion (Misc queries) 5 September 15th 05 04:20 AM
Indexing a row ecohen1 Excel Worksheet Functions 6 July 20th 05 06:11 PM


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"