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