I have attached a file, where subtotals are calculated with the appropriated currency depending on the inserted unit price/currency:
=IF(B4="";"";IF(C4="";(VALUE(D4*B4&""&" €"));(C4*B4)&""&" $"))
The total result for each currency gives 0 (cells E13 & E14). Is there maybe another way to find the solution ?
Thanks