I am trying to figure out how to sum a row or column and to check weather a cell contains a Dollar "$" amount or Euro "€" Ect.
When I Calculate I need to convert everything to US dollar amount
in the expense report, I have the exchange rate.

I think I need a if cell a2 = "€" a2*"1.423" else if cell a2 = "&" a2*"0"
else if cell a2 = "£" a2*1.003"

Does this make sense?