Re: [libreoffice-users] Calc multiplication & division formulas acting strangely (Mac 5.2.3)

Thanks again Brian. Appreciate that you take time to comment and help! Some additional comments inline below. On 7 November 2016 at 23:53, Brian Barker wrote: > At 14:20 07/11/2016 -0500, Bonly Noname wrote: > >> On 2016-11-06 8:43 PM, "Brian Barker"

Re: [libreoffice-users] Help with LOCalc formula (SOLVED)

Hi, Bruce, Remy, Brian and Jim Thank you for your kindness and answers. Tonight while following the election on TV I'll have a lot to do when giving the VLOOKUP() a new try according to your advice. I must have done bad thinking -- perhaps getting old. Anyway I again learn a lot. Best regards

Re: [libreoffice-users] Help with LOCalc formula

Try this. =IF(B1="","",OFFSET($Z$20,MATCH(B1,$B$20:$B$35,0)-1,25)) -- Jim -Original Message- From: "Pertti Rönnberg" To: "users@global.libreoffice.org" Cc: "Pertti Rönnberg" Sent: Mon, 07 Nov 2016 8:00 Subject: