Multiply a number of cells by a value

mvivian · Apr 17th, 2002, 01:42 PM

I have a table of data that needs displaying in two currencies, £ and $ (not simulataneously). How do I write a macro that multiplies all values in the table by 1.4 (if currently in £) or 0.6 (if currently in $) to give the other currency

Thanks

Ricky Morris · Apr 17th, 2002, 01:48 PM

This can be done relatively simply with a macro, but why not use a formula in an adjecent column instead?

Apr 17th, 2002, 01:48 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	This can be done relatively simply with a macro, but why not use a formula in an adjecent column instead? __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 01:42 PM	#1
mvivian New Member Join Date: Apr 2002 Location: London England Posts: 6	I have a table of data that needs displaying in two currencies, £ and $ (not simulataneously). How do I write a macro that multiplies all values in the table by 1.4 (if currently in £) or 0.6 (if currently in $) to give the other currency Thanks