Re: [libreoffice-users] Question on INDIRECT()

Hi Rob, did you ever get this answered.
You could use something like the below for the cells with a '+' in them.
Assuming below is row 4, vertical bars are cell borders.
|25+15|=VALUE(LEFT(A4,FIND("+",A4)-1))+VALUE(RIGHT(A4,LEN(A4)-FIND("+",A4)))|

If you need it to be generic for with/without the + then you could use 
an IF to check, shown below for row 5.
=IF(ISNUMBER(A5),A5,VALUE(LEFT(A5,FIND("+",A5)-1))+VALUE(RIGHT(A5,LEN(A5)-FIND("+",A5))))

Steve

On 18/10/2021 12:13, Rob Jasper wrote:
> Hi list-users,
>
> I have the following question:
>
> I have in column A value either a number, or string in the format  <NR>+<NR>, in col B I want to 
> calculate what’s in Col A
> e.g.:
>
>        10       10
> 12+72   84
>        33       33
> 66+72   138
>
> So, I tired the formula =INDIRECT(“=“&A1) but I only get REF!
> What am I doing wrong here, and how can I achieve what I want?


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy