Spreadsheet help
if KWh is above 670 then C23-670 multipy
by C29, but if below 670, then answer should be 0 (zero)
Google for "open office if statements".
It's probably
=IF(c31670;(c23-670)*c29;0)
if I've got the cell numbers right. There's probably a more elegant way ....
|