hmz you say:-

"the value"

What do you mean by this and in which cell is it to be found?

"hmz" wrote:

hi, i am trying to create an if statement with different currency. for example:

Col. A B
C
Value: EUR USD

(can either be EUR, USD)


(if "A2" is a Euro, then the value goes in "B2." If the Value is in US
dollars, then value has to go in "C2." )

How do i write a statement to that can identify between currencies? Thank
you,




--
hmz
nyc