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

t;p...@elisanet.fi> Cc: "Pertti Rönnberg" <p...@elisanet.fi> Sent: Tue, 08 Nov 2016 1:52 Subject: 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

Re: [libreoffice-users] Help with LOCalc formula

g" <p...@elisanet.fi> Sent: Mon, 07 Nov 2016 8:00 Subject: [libreoffice-users] Help with LOCalc formula Best Spreadsheet Experts, May I ask for help having a more elegant formula in LOCalc (v.5.0.3; win10) Description I try to get a little extra to my pension savings by experimenting on the s

Re: [libreoffice-users] Help with LOCalc formula

At 17:58 07/11/2016 +0200, Pertti Rönnberg wrote: I have a spreadsheet with two ranges ­ range(1) directly above range(2). r(1) specifies per row every specific purchase/sell event (date, company name, amount, etc). To calculate the actual "to-day"-result for this specific event (row) we

Re: [libreoffice-users] Help with LOCalc formula

Le lundi 07 novembre 2016 à 17:58 +0200, Pertti Rönnberg a écrit : > > r(1) specifies per row every specific purchase/sell event (date, company  > name, amount, etc). > > To calculate the actual "to-day"-result for this specific event (row) we  > need the "to-day"-value for this company's share

Re: [libreoffice-users] Help with LOCalc formula

I think VLOOKUP might work. In cell X1 try this: =VLOOKUP(B1,B$20:C$22,2,0) Copy down as needed; Adjust 2nd parameter (B$20:C$22) as needed. On Mon, Nov 7, 2016 at 10:58 AM, Pertti Rönnberg wrote: > Best Spreadsheet Experts, > May I ask for help having a more elegant formula

[libreoffice-users] Help with LOCalc formula

Best Spreadsheet Experts, May I ask for help having a more elegant formula in LOCalc (v.5.0.3; win10) Description I try to get a little extra to my pension savings by experimenting on the share market and follow up the results using Calc (not a database). I have a spreadsheet with two ranges –