On Wed, 08 Jul 2009 15:26:25 GMT, Stuart Noble wrote:

f 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".

Try

http://wiki.services.openoffice.org/...tation/How_Tos

has a load of stuff that I found useful.
--
Peter.
The head of a pin will hold more angels if
it's been flattened with an angel-grinder.