Forum Discussion
Formulae / approach advice please
Hi, I wonder if you can provide some guidance? Can excel choose a value of a cell so that some logic is true? Allow me to explain...... In my example, I want to compare the impact of an ele...
Beeeemster That would be:
=Kw*( peak_rate - flat_rate ) / ( peak_rate - offpeak_rate )
This will return the break-even point for off-peak usage. I.e. dual rate cost = flat rate cost