Hello Pi community,
I'm looking for some help on how i can take one calculated data together with the "IF" statement of excel. The problem is that I have one variable that I need the average of temperature per hour but only if the equipment is indicating that is ON.
Is something like: =IF("TagON/OFF"="ON",advcalcdata average for the tag of temperature)
Wishing the best for all the community,