Quick Excel formula question before I go on holiday tomorrow!

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...

--
Thanks & kind regards,
-pp-

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 ;-)

--
HTH

Bob Phillips

"Pheasant Plucker®" <pheasant@plucker.not> wrote in message
news:eOnwp7AwFHA.3252@TK2MSFTNGP10.phx.gbl...
> 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...
>
> --
> Thanks & kind regards,
> -pp-
>
>

Thanks Bob,

Worked a treat!

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

Kind regards,
-=pp=-

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uulbobBwFHA.2620@TK2MSFTNGP09.phx.gbl...
> 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
;-)
>
> --
> HTH
>
> Bob Phillips
>
> "Pheasant Plucker®" <pheasant@plucker.not> wrote in message
> news:eOnwp7AwFHA.3252@TK2MSFTNGP10.phx.gbl...
> > 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...
> >
> > --
> > Thanks & kind regards,
> > -pp-
> >
> >
>
>