Hi Johnny,
Johnny schrieb:
[..]
I want nothing displayed if the other cells have nothing in them.
A1 = 10
A2 = 20
A3 = 30
A4 = sum(A1 + A2 + A3 - 5)
Prior to entering data into A1 thru A3, A4 will display -5. I want A4 to be
blank, or at least appear so until something is entered into A1,2 or 3 that
will bring A4's value>= 0.
If you really want only change the display, then use the format code
Standard;"";Standard
as cell format.
Kind regards
Regina
--
For unsubscribe instructions 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
