At 19:11 10/10/2013 +0200, Hylton Conacher wrote:
The below formula calculates H4 =IF(0<G4<=$G$20, ...
Just to add to what I wrote before, if you want to test a condition that you would write mathematically as A<B<C, you need to use AND(A<B;B<C) instead.
Brian Barker -- To unsubscribe e-mail to: firstname.lastname@example.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