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

At 01:13 18/10/2021 +0200, Rob Jasper wrote:
> I have the following question:

If, as here, you prepare your question as a reply to a previous 
message when it is nothing of the sort, it will be lost in the 
previous thread and may not be seen by possible helpers.

> I have in column A value either a number, or string in the 
> format  <NR>+<NR>,  ...

Nauru? Norwich postcodes? National Rail? Noise reduction?

> ... 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, ...

Probably thinking INDIRECT() does something different from what it does.

> ... and how can I achieve what I want?

First solution: don't enter your data like that in the first place.

I don't think there is any simple method to do what you ask in a 
general fashion. If, as you suggest, the operator is always "+", you could use
=IF(ISNUMBER(A1);A1;LEFT(A1;FIND("+";A1)-1)+MID(A1;FIND("+";A1)+1;99))
You could make this simpler if you knew that the numbers in the 
expressions were always of two digits.

I trust this helps.

Brian Barker


--
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