Quick Excel formula question before I go on holiday tomorrow!

[Pheasant Plucker®]

I would like to keep track of my credit card expenditure while away on
holiday Florida.

I was thinking of an Excel spreadsheet I could keep on my PDA - something
along the lines of;

A B C
1 AVAILABLE 2000 UKP 3600 USD
2
3 PARKING 70 ???
4 HOTEL ??? 250

5-20 etc. etc.

21 SPENT 208 376
22 BALANCE 1792 3224


I have taken the conversion rate in the example above from
www.fxtop.com/en/cnv.htm

As my Excel knowledge is limited as I see it my problem is getting the Excel
spreadsheet formulas correct to;

1. Automagically convert the entered amount - whether in UKP or USD to
convert to the other currency.
Example: I enter 70UKP in B3 and I would want the equivalent displayed in C3
in USD
or
Example: I enter 250USD in C4 and I would want the equivalent displayed in
B4 in UKP

2. The running total SPENT should be easy even for someone like me!
Example: SUM=(B3:B20) for UKP or SUM=(C3:C20) for USD for example?

3. The credit available to spend BALANCE should be straightforward also?
Example: SUM=(B1-B21) or SUM=(C1-C21) for example?

4. I have tried a couple of ideas to no avail and also notice that the
totals in C21 & C22 are displayed in UKP and not USD?

Obviously this would have to work on Pocket Excel on my iPAQ 4700 so maybe
this will influence the use of certain formulas/functions?

I fly tomorrow morning so that doesn't give me (you? much time!

<ducking> ;^)

Any other way of tracking this would be greatly appreciated...

 

[Bob Phillips]

Don't know what PDA supports, but put the rate in say M1 (1.8 I can't get
that rate anywhere!).

Then use this formula in B4,

=C4/$M$1

In C3

=B3*$M$1

and just use those whenever you want one way or the other.

I always use a high-tech notebook to track my spending, works perfectly ;-)

 

[Pheasant Plucker®]

Thanks Bob,

Worked a treat!

If only Mastercard themselves could have kept such a tight control over
their records...;^)

Kind regards,
-=pp=-