Excel Problem

  Dirty Dick 17:43 28 Jun 04

I run a "booking" programme in MS Excel. I have booking sheets for several years which has rental costs alongside the weeks. The rental costs are added up using a formula and displayed in a "total" cell. The total is transferred onto an "expenditure sheet" Total income minus total expenses = Profit. The expenses are in Euros, which are converted to Pounds Sterling at the appropriate exchange rate. Now to the problem........... The Exchange Rate fluctuates throughout the year. How can I update my workbook to show the relevent rate at That time. Hope you can follow this !!

  VoG II 18:31 28 Jun 04

Does click here help?

This thread is now locked and can not be replied to.

Microsoft Surface PC release date, price and specs: All-in-one Surface PC to directly rival iMac

1995-2015: How technology has changed the world in 20 years

Best Photoshop video tutorials: 8 video tutorial websites for Photoshop

Apple's event invitations decoded: A look back at 16 of Apple's most cryptic invites | Clues in…