Hi
Tried a few things here but none seem to work.
I have two columns, one with a price and the second is either a "$" or
"£".
I wish to Convert the price to pounds sterling if the value in the
second column is a "$".

Has anybody got any ideas how to do this and does it need to go on a
button?

Many thanks

Wayne


--
QuickLearner
------------------------------------------------------------------------
QuickLearner's Profile: http://www.excelforum.com/member.php...o&userid=35483
View this thread: http://www.excelforum.com/showthread...hreadid=559837