Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jnf
 
Posts: n/a
Default formulars

i want to calculate what quantities of each british curency notes and coins
there are in a set amount ie how many £20,£10,£5,£1,50p,20p,10p,5p,2p,1p. i
have used various formulars but when i round it of it gathers the odd amounts
to the end and gives a wrong answer
can anyone help
jnf
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
need help with formulars greenfrog Excel Discussion (Misc queries) 2 January 19th 06 07:56 PM
Worksheet formulars PK Excel Worksheet Functions 4 January 1st 06 04:01 PM
Sorting using nothing but formulars? jonas_nielsen Excel Discussion (Misc queries) 0 August 23rd 05 08:26 AM
Deleting Cells, but not ones with formulars scriblesvurt Excel Discussion (Misc queries) 6 July 20th 05 01:57 PM
Can I put 2 formulars in one cell greg071190 Excel Worksheet Functions 7 December 23rd 04 06:40 PM


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"