Ben,
Where are you getting the value of 4 Euros from?
Assuming that the current value of a Euro is in Cell A1 try this in
Cell I27

IF(B26=40(A1),(4(A1))*100,(2(A1)*100)

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=470922