changing money

[firouz]

hi every body
i am new in here and i really needs help in this ...please help mr
set up a spreadsheet to calculate the amount of french franc you can buy.all the answers should be rounded to the nearest french franc .
you have 1£ equals 9.2754 franch franc

thanks a lot

[Nick Hodge]

If you exchange rate is in A1 and your £ value in B1 then in C1 enter

=ROUND(B1*A1,2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"firouz" <[email protected]> wrote in
message news:[email protected]...
>
> *::
>
> hi every body
> i am new in here and i really needs help in this ...please help mr
> set up a spreadsheet to calculate the amount of french franc you can
> buy.all the answers should be rounded to the nearest french franc .
> you have 1£ equals 9.2754 franch franc
>
> thanks a lot::*
>
>
> --
> firouz
> ------------------------------------------------------------------------
> firouz's Profile:
> http://www.excelforum.com/member.php...o&userid=35235
> View this thread: http://www.excelforum.com/showthread...hreadid=550119
>

[Marcelo]

Hi, firouz

assuming that you have the French franc figure on the E3 cell
try:

=ROUNDDOWN((e3/9.2754);0)
you also put the exchange rate on another cell and makes the reference
instead to put 9.2754 on the formula.

does it helps?
regards from Brazil
Marcelo


"firouz" escreveu:

>
> *::
>
> hi every body
> i am new in here and i really needs help in this ...please help mr
> set up a spreadsheet to calculate the amount of french franc you can
> buy.all the answers should be rounded to the nearest french franc .
> you have 1£ equals 9.2754 franch franc
>
> thanks a lot::*
>
>
> --
> firouz
> ------------------------------------------------------------------------
> firouz's Profile: http://www.excelforum.com/member.php...o&userid=35235
> View this thread: http://www.excelforum.com/showthread...hreadid=550119
>
>