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: [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

Reply via email to