View Single Post
  #36   Report Post  
Posted to free.uk.diy.home,uk.d-i-y
the_constructor[_2_] the_constructor[_2_] is offline
external usenet poster
 
Posts: 274
Default Spreadsheet help


"PeterC" wrote in message
...
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.


My thanks to everyone for your most helpful comments. I now have the
spreadsheet working superbly.
Kindest regards,
JIm