Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing money
*:: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
changing money
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|