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+unsubscr...@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