Prasad

Hope I understand now. I am seeing a grid with the number in A2, Titles in
B1:H1 as follows: 100, 50, 20, 10, 5, 2, 1). The following formula in cells
B2:H2 respectively

=INT(A2/$B$1)
=INT((A2-(B2*$B$1))/$C$1)
=INT((A2-((B2*$B$1)+(C2*$C$1)))/$D$1)
=INT((A2-((B2*$B$1)+(C2*$C$1)+(D2*$D$1)))/$E$1)
=INT((A2-((B2*$B$1)+(C2*$C$1)+(D2*$D$1)+(E2*$E$1)))/$F$1)
=INT((A2-((B2*$B$1)+(C2*$C$1)+(D2*$D$1)+(E2*$E$1)+(F2*F1)))/$G$1)
=INT((A2-((B2*$B$1)+(C2*$C$1)+(D2*$D$1)+(E2*$E$1)+(F2*$F$1) +(G2*$G$1)))/$H$1)

There will undoubtedly be a more elegant array solution, but this appears to
work

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


"prasad" wrote in message
...
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.