Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 29 Aug 2017 15:00:35 +0200Adding values from a named listhttps://ask.libreoffice.org/en/question/127774/adding-values-from-a-named-list/ I have a sheet of resistors, names in one column and value in an other column, it is possible to lookit up with VLOOKUP or HLOOKUP but I should like to get the values automatic added from a list of resistor names.
Sheet 1: list of resistor names and its value; Sheet2 a column given a list of resistor names and a field there the resistors is added up. Say "R1+R2+R342+A34" and its value it's added up, other formula should work also if operator is possible,
operator @ as VLOOKUP and given tables of names and value. "@R1+@R2+@R342+@A34"
More complex ""@R1//@R2" there R1 and R2 resistors are in parallel recording formula R=1/(1/R1+1/R2) there // is an other operator. Now I don't know if that is working in any languages or exchange @ and // with SER(R1,R2) och PA(R1,R2) there SER o PAR is working more as a function.
Its little hard to explain. HelgeTue, 29 Aug 2017 15:00:35 +0200https://ask.libreoffice.org/en/question/127774/