PDA

View Full Version : Solved: How to find subtotals from formula currency converted cells



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

austenr
12-03-2010, 11:28 AM
Do you want the totals to stay in their oroginal currency form?

austenr
12-03-2010, 11:35 AM
you could add a helper column as in this example. Is this what you want?

p45cal
12-03-2010, 12:21 PM
No doubt similar to austenr's attached.

guatelize
12-08-2010, 04:51 AM
Thanks for your solutions