
Hello, Im making an invoice and need some help!
How can I create a formula that automatically calculates the 'Total' considering that the prices (Price 1 and Price 2) are in the same cell, separated by rows, and in a 'number/text' format (50EUR)? Also, how can this formula calculate new prices that I additionally enter (for example, if I added Price 3, Price 4, etc)?
How can I then create another formula to divide the total into two percentages, and displayed in a single cell, separated by rows? (for example, 30% and 70% as shown in the picture above)
Thank you