Richard

I've had no response from the poster yet but I suspected he wanted to know
how many 100's, how many 50's, how many 20's, etc were in the number in A1,
so in the example given (6566) (I think he has confused his examples), you
end up with 65x100s, 1x50s, 0x20's, 1x10s, 1x5s, 0x2s and 1x1s. (I think he
just left gaps instead of zeroes)

I suspect we'll know when time zones allow ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Richard Buttrey" wrote in
message ...
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
__________________________