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
Do you want the totals to stay in their oroginal currency form?
Peace of mind is found in some of the strangest places.
you could add a helper column as in this example. Is this what you want?
Peace of mind is found in some of the strangest places.
No doubt similar to austenr's attached.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Thanks for your solutions
Posting Permissions
Reply With Quote
