Hello Jean-Francois, On Mon, 06 Jun 2011 00:07:34 +0200 (your time) you said:
> There's a STYLE() function. Could it be of any use here? Thankyou! You pointed me in the right direction and I finally got there...I think :-D Just been testing it and this seems to work: =SUM((N13+L14)-(P14+R14))+STYLE(IF(CURRENT()<1000,"BPC1";IF(CURRENT()<=2000,"BPC2";IF(CURRENT()<=3000,"BPC3";IF(CURRENT()<=4000,"BPC4";"BPC5")) although Calc instantly coverts the above to: =SUM((N13+L14)-(P14+R14))+STYLE(IF(CURRENT()<1000,"BPC1",IF(CURRENT()<=2000,"BPC2",IF(CURRENT()<=3000,"BPC3",IF(CURRENT()<=4000,"BPC4","BPC5"))))) which, from what I can see, works. Took me a while to work out how to nest the IFs. -- Si (PLO) #17654. Dew In Show Ergo? ¶ Auxiliary Information: • LibreOffice 3.4.0 OOO340m1 (Build:12) • Windows XP Pro 5.1.2600 Service Pack 3 -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted