Martin wrote:
"Stuart Noble" wrote in message om...
Jules wrote:
On Mon, 06 Jul 2009 16:07:06 +0100, the_constructor wrote:

Got a little problem trying to sort out a formula for a spreadsheet.
I suspect possible solutions depend on whose spreadsheet app you're using,
and you don't say...


This might help

http://wiki.services.openoffice.org/...c:_IF_function

Things are different in Excel, but in cell c31 try

=IF(c23670; c23*c27; "")

I imagine it needs the equals sign before it, but it doesn't say so in
the wiki. Substitute a zero for "" if you want it to display a zero

I suspect (in excel) you need to use comma separators, not semi-colons.

Also, "" will normally display 0, so I suggest use 0 anyway - and hence ensure the cell is numeric, for any subsequent calcs whcih depend on it.





There's a free energy tracker spreadsheet here

http://www.energywatcher.com/2009/03...-tracking.html

In Excel but I assume it will run in OpenOffice. Needs modifying for UK
but looks quite well designed at first glance