On Sun, 23 Oct 2005 01:53:01 -0700, prasad
wrote:

I have entered A1 Cell= 6500

1) 100 50 20 10 5 2 1
2) 65 1 1 1 1
3) 6500 50 0 10 5 0 1

Please see the above table I have entered a) Rupees Value b) I want Answer
like that c) actual calculation of cell

My question is I want to know that how much times I have entered e.g.
100,50,20,10,…… how much times in the value 6566. Answer is 65,1,1,......
I want to function for that.

Can you describe what you are trying to achieve a little more clearly
please?

It seems that you're trying to create some function which relates the
numbers 100, 50, 20 etc., with the number in A1, and produce the
result 65, 1, ?,?,?,?,? and 6500, 50, 0, 10, 5,0,1

However it's not clear to me how these are related and why for
instance you are only showing five results in 2)

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________