"Johnny Rosenberg" <gurus.knugum@gmail.com> wrote in message news:CADo7T4d47+3cOmv6+rbHbLoeB6wpiLHF3isRFm0O5qmPkcx62Q@mail.gmail.com...
2011/12/3 Pedro <pedlino@gmail.com>:Johnny Rosenberg wroteI could agree with that, but it would have been nice if they thought of that since 1.0 and not changing it on the way, breaking a whole lot of spreadsheetsâ€¦I see your point. But this was wrong.It's not a change of plans it's simply a correction. And not fixing it wouldbreak a lot of other spreadsheets ;) Johnny Rosenberg wroteIs there another way to make A2 look empty in this case, making it useable for calculations? Something like the following: =IF(A1=6;SomethingNiceToPutHere;B1)
<snip> What happens if you set A3 to be =((A2&"0")/10+27)So, for example, if A2 is 30, A2&"0" is 300; divide by 10 gives 30 again and then add the 27. But if A2 is "" (empty), A2&"0" should force a numeric zero which stays the same when divided by 10.
-- Harold FuchsLondon, England
-- For unsubscribe instructions e-mail to: users+help@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