I need a formula that looks in Cell A and if it is a Euro amount, then the formula that calculates in Cell B multiplies times the exchange rate that I set then adds some other figures. If the formula in Cell A is a USD amount, then the formula that calculates in Cell B does not multiply by the exchange rate but does continue to add in the other figures. Can someone help with this?