Forum Discussion

garygiles01's avatar
garygiles01
Copper Contributor
Dec 06, 2022
Solved

How to use IF statements to calculate power usage and cost

Hello,   I am trying to use IF statements (I think this is correct) to work out power usage of a machine at certain times to therefore workout the cost associated with running this.   Please see ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Dec 12, 2022

    garygiles01 

    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's avatar
HansVogelaar
MVP
Dec 07, 2022

garygiles01 

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?

garygiles01's avatar
garygiles01
Copper Contributor
Dec 12, 2022

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

Resources