guatelize
12-03-2010, 04:26 AM
:banghead:
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 ? : pray2:
Thanks
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 ? : pray2:
Thanks