View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135 via135 is offline
external usenet poster
 
Posts: 94
Default finding out denominations.!

hi

i'm having values in multiples of 100 in COL A.
i want the quotients in COL B [divisor 500] & COL C [divisor 100]
explained as under:

COL "A" - COL "B" - COL "C"

100 - 0 1
200 - 0 2
500 - 0 5
600 - 1 1
700 - 1 2
1000 - 1 5
1200 - 2 2
1500 - 2 5
1600 - 3 1
1900 - 3 4
2000 - 3 5
2100 - 4 1
2500 - 4 5
50000 - 99 5