[libreoffice-users] Question on INDIRECT()

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