Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
query information
I'm not really sure how to ask this but I will try. I'm quering information
from a website. I'm taking the information of devices being on and off and trying to calculate that into daily expense of running that individual peice of equipment. So I guess I'm looking for a code that says something like If A1 = On then I put in my formula to calculate Kiliwatt hours. Sorr if this is confusing |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
query information
Not sure exactly what you are asking but..
Public Function TotalPower (argDevices As Range) As single dim cell as range dim temppower as single for each cell in argdevices if lcase(cell.value)="on" then temppower =temppower +1 'Or however you calculate the power end if next TotalPower=temppower End function NickHK "tinytol" wrote in message ... I'm not really sure how to ask this but I will try. I'm quering information from a website. I'm taking the information of devices being on and off and trying to calculate that into daily expense of running that individual peice of equipment. So I guess I'm looking for a code that says something like If A1 = On then I put in my formula to calculate Kiliwatt hours. Sorr if this is confusing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the information returned from a query? | Excel Discussion (Misc queries) | |||
How do you get information from an Excel Web Query into Access? | Excel Worksheet Functions | |||
Getting Information from a query in ACCESS | Excel Worksheet Functions | |||
query information | New Users to Excel | |||
How locate connection information for web query? | Excel Programming |