Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing values in one column based on values in another?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
Get values in a column based on values in two other columns | Excel Programming | |||
Calculating values to column D with formula based on values column A | Excel Programming | |||
Create Worksheets Based Upon Changing Column Values in XP | Excel Programming |