Hi, Le 19/10/2013 14:36, Hylton Conacher (ZR1HPC) a écrit : > > The initial formula is: > =IF(0<G4<=$G$20,G4*$F$20,IF($G$20<G4<=$J$20,(G4-$G$20)*$I$20+($F$20*$G$20),IF($J$20<G4<=$M$20,(G4-$G$20-$J$20)*$L$20+(($G$20*$F$20)+($J$20*$I$20),IF($M$20<G4<=$P$20,(G4-$G$20-$J$20-$M$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20),IF(G4>$P$20,((G4-$G$20-$J$20-$M$20-$P$20)*$O$20+(($G$20*$F$20)+($J$20*$I$20)+($M$20*$L$20)+($O$20*$P$20))))))))))
this is waaay too convoluted to be easily checked. > > There must be an answer and or my formula syntax is wrong unbeknown to me. > Sure, there is. As your request looks very much like your previous one, I highly encourage you to read Brian's answer to that one: it's filled will good advice. IOW, when you can write your problem down using common speech (not some spreadsheet language), I'm sure you'll turn having found the solution by yourself. -> I share Brian's idea about using VLOOKUP() through a 3 lines set of data. HTH, -- Jean-Francois Nifenecker, Bordeaux -- 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
