View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default changing values in one column based on values in another?

No buttons.
Say the price is in Column A and the symbol in Column B, all starting in row
1. In some blank column, in row 1, enter this formula:
If(B1="$",A1*XXX,A1)
where XXX is the current conversion factor of dollars to pounds.
Drag this formula down as far as your data in Column A:B goes.
Select all the occupied cells in the above formula column.
Do Edit - Copy.
Select A1.
Do Edit - Paste Special - Values - OK.
Delete all the values in the formula column.
You don't say what you want done with the dollar sign. Assuming that you
want to change all the dollar signs to pound signs, go back to the now blank
formula column above. In row one enter this formula:
If(B1="$","£",B1).
Drag this formula down as before.
Copy all the values.
Select B1.
Do Edit - Paste Special - Values - OK.
Delete all the values in the formula column.
HTH Otto
"QuickLearner"
wrote in message
news:QuickLearner.2aq7ca_1152528853.3014@excelforu m-nospam.com...

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