Here is the formula in column L:
Column D is units; column G is the extension of EF (qntycost); column K is tax; M3 is markup rate. Not every line item, or row, have tax; so K is sometimes white space.
This formula works in Open Office, Google spreadsheets, etc. But in Libre the answer is #VALUE!
I have replaced the commas with semi-colons but the program changes them back to commas.
I have replaced the blank (" ") with “0” (without quotes) but the answer is #VALUE!
I have added parenthesis to encompass the entire third set, as in ((G5+K5)+(G5+K5)*$M$3)).
Any help here? Thanks in advance.