On 07/09/2014 11:28 AM, Brian Barker wrote:
Yes: there is the IF() function: is that a close enough equivalent?
Just put
=IF(condition;expression-for-true;expression-for-false) .
Your expression for false may well be consecutive double-quote marks,
representing the null string.
Thanks Brian
I have managed to get rid of the 'DIV 0' problem but still have a
problem with a decreasing total.
My DEC TOTAL formula is 'Current Cell minus the Cell above' and this
echos the last result down the whole Spreadsheet. Is there a way round
this as well?'
IanW
Pretoria RSA
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
