Hi All
I have several of Spreadsheets that work with monthly figures. They also
have columns with calculations of these figures. (ie Totals, averages
etc). At the moment I get a lot of 'DIV by Zero' results and the current
total repeating BELOW the current month.
Is there a way to only show calculated results on "active" (ie current)
month rows?? Maybe the equivalent of the old 'If - Then' Basic function.
(If there is a figure >0 in column B then calculate column C.
Would be interested to know - thanks.
OpSys PClinuxOS, LO 4.1.3.2.
IanW
Pretoria RSA
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
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