Hello,
My sheet has a column of 6000 rows that are priced in British Pounds.
I would like to create two additional columns that convert the pricing into US$ dollars and another for Canadian dollars.
Any suggestions?
Hello,
My sheet has a column of 6000 rows that are priced in British Pounds.
I would like to create two additional columns that convert the pricing into US$ dollars and another for Canadian dollars.
Any suggestions?
I feel like I am missing something, but is there more to it than simply multiplying by the appropriate exchange rate? Assuming British Pounds is in column A and your exchange rates are in E1 (US dollar) and F1 (Canadian dollar). B1 would be =A1*E$1 (note the mix of relative and absolute references) for the US dollar, then copy/paste/fill into B1:C6000.
Originally Posted by shg
Thank you Mr Shorty. I am not formula savvy. I understand what you are suggesting and I do not believe you are missing anything. When I get a chance to work on that I will let you know how I made out.
Many thanks for taking the time to answer. EVERYONE here that have helped me over the years are very gracious!!
Is there an easy way to copy the formula down the 6000 rows, without having to drag it all the way down?
dJE
Move the cursor to the bottom right corner of the formula cell until it becomes a bold black + shape, then double-click.
Rory
Ooooh that's nice! thank you
dJE
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks