|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
09-28-2003, 02:22 PM
|
#1 |
|
Member (7 bit)
Join Date: Aug 2003
Location: Hinckley in Leicestershire
Posts: 110
|
Excel!
Hey iv got some work to for college where i have to make a spreadsheet that will convert pounds sterling into 8 different currencies!
I havnt got a ****ing clue how to do it! Anyone know how to? Cheers, Ben. |
|
|
|
09-28-2003, 03:37 PM
|
#2 |
|
Member (10 bit)
Join Date: Apr 2003
Location: Western Canada
Posts: 617
|
|
|
|
|
|
09-28-2003, 03:42 PM
|
#3 |
|
Member (11 bit)
Join Date: Aug 2003
Location: NJ
Posts: 1,099
|
well that's easy. I attached an excel file that converts Celcius to Kelvin and F. It's in a zip file since the forum won't allow me attach .xcl files. The same concept applies to currency conversion.
Use the "=" and the cell numbers to make the formula. Cells D3 and D4 hold the conversion formula. They take the numbers from D1, D6, and D7, apply the formula and display the results. Take 2 variables and apply the conversion formula. I know it's a bit crude but it should work. I'll do it for you if you can give me the conversion rates for the 8 currencies and if you can send $10 USD to my paypal account  edit: Here's the excel file...I for got to attach it. http://www.strike9.com/file.ashx?pat...conversion.xls
__________________
P4 2.6C @ 3.12 || ASUS P4C800-E Dlx || Antec SOHO File Server w/ 5 case fans || Antec TruePower 430w PSU || 2 x 512MB Crucial PC3200 DDR || 280GB of total storage 7200rpm ATA100 8mb cache || LiteOn CDRW 52x32x52 || LiteOn DVD+/-RW SOHW-812S || WinXP Pro || Solarism 15" TFT LCD || 500VA TrippLite UPS || Logitech MX-700 Duo || ATI 9800 AIW || Sennheiser HD-555 Last edited by james8547; 09-28-2003 at 03:47 PM. |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
