Forum Discussion
How to use IF statements to calculate power usage and cost
See the attached version. The formulas are simpler since you want to calculate the periods for every individual day.
The cost now takes the change in rate into account.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Thanks HansVogelaar, very much appreciated.
Here is the link to the sheet. Sheet 1 was your first iteration.
Thank you again in advance.
https://1drv.ms/x/s!Am09L0ilmxefb7GNEPbPXOtkSDc?e=0TW6pC
See the attached version. The formulas are simpler since you want to calculate the periods for every individual day.
The cost now takes the change in rate into account.
HansVogelaar Many thanks indeed!
This is sincerely appreciated and works well. I just had to manipulate the 'cost' column so it calculated the rates as a percentage of the Kw/hrs used.
Only posting the revised link if it's of interest. Otherwise thanks again.
https://1drv.ms/x/s!Am09L0ilmxefc13Z4Dlxpo0OZSI?e=YaR4sb
G