Help needed

[Shakeel Ahmad]

Please Help me in the following ::


For Example in Cell A1 I write (15860) Rupees '''Rupees is
Pakistani Currency'

now it should be divided into parts as under:::>

A2 >> [heading is Thousands] > 15
A3 >> [heading is Five Hundreds] > 01
A4 >> [heading is Hundreds] > 03
A5 >> [heading is Fifty] > 01
A6 >> [heading is Tens] > 01

in this example the amount has been divided into parts that it has 15-notes
of Thousand, 1-note of Five-hundred, 3-notes of Hundreds,
1-note of Fifty and 1-note of Ten.

how can i do this, help please.

 

[JE McGimpsey]

one way:

A2: =INT(A1/1000)
A3: =INT((A1-A2*1000)/500)
A4: =INT((A1-A2*1000-A3*500)/100)
A5: =INT((A1-A2*1000-A3*500-A4*100)/50)
A6: =INT((A1-A2*1000-A3*500-A4*100-A5*50)/10)

 

[Andy]

Please Help me in the following ::


For Example in Cell A1 I write (15860) Rupees '''Rupees is
Pakistani Currency'

now it should be divided into parts as under:::>

A2 >> [heading is Thousands] > 15
A3 >> [heading is Five Hundreds] > 01
A4 >> [heading is Hundreds] > 03
A5 >> [heading is Fifty] > 01
A6 >> [heading is Tens] > 01

in this example the amount has been divided into parts that it has
15-notes of Thousand, 1-note of Five-hundred, 3-notes of Hundreds,
1-note of Fifty and 1-note of Ten.

how can i do this, help please.

The layout I used is to have the headings in Row 1 from B1 to F1 to
(1000,500,100,50,10)
A3 has the figure '15860'
The formulae are as follows.
B2 =INT(A2/B1)
C2 =INT((A2-(B1*B2))/C1)
D2 =INT((A2-(B1*B2)-(C2*C1))/D1)
E2 =INT((A2-(B2*B1)-(C2*C1)-(D2*D1))/E1)
F2 =INT((A2-(B2*B1)-(C2*C1)-(D2*D1)-(E2*E1))/F1)

Not the most elegant solution but it works and, hopefully, is
straightforward to follow

Andy

 

[Rick Rothstein \(MVP - VB\)]

For Example in Cell A1 I write (15860) Rupees '''Rupees is

Pakistani Currency'

now it should be divided into parts as under:::>

A2 >> [heading is Thousands] > 15
A3 >> [heading is Five Hundreds] > 01
A4 >> [heading is Hundreds] > 03
A5 >> [heading is Fifty] > 01
A6 >> [heading is Tens] > 01

in this example the amount has been divided into parts that it has
15-notes of Thousand, 1-note of Five-hundred, 3-notes of Hundreds,
1-note of Fifty and 1-note of Ten.

Here is another way...

A1: 15860
A2: =INT(A1/1000)
A3: =INT(MOD(A1,1000)/500)
A4: =INT(MOD(MOD(A1,1000),500)/100)
A5: =INT(MOD(MOD(MOD(A1,1000),500),100)/50)
A6: =MOD(MOD(MOD(MOD(A1,1000),500),100),50)/10

Rick

 

[Ron Rosenfeld]

Please Help me in the following ::


For Example in Cell A1 I write (15860) Rupees '''Rupees is
Pakistani Currency'

now it should be divided into parts as under:::>

A2 >> [heading is Thousands] > 15
A3 >> [heading is Five Hundreds] > 01
A4 >> [heading is Hundreds] > 03
A5 >> [heading is Fifty] > 01
A6 >> [heading is Tens] > 01

in this example the amount has been divided into parts that it has 15-notes
of Thousand, 1-note of Five-hundred, 3-notes of Hundreds,
1-note of Fifty and 1-note of Ten.

how can i do this, help please.

A B
1 15860
2 1000 =INT(A1/A2)
3 500 =INT(($A$1-SUMPRODUCT($A$2:$A2,B$2:B2))/$A3)
4 100 Select B2 and fill down
5 50
6 10


--ron

 

[Shakeel Ahmad]

Thank you very much.... all the four formulas are useful and helped me. the
Rick Rothestein's formula was easier than the others but all are good. I am
thanking all of you.

best regards,
Shakeel.

For Example in Cell A1 I write (15860) Rupees '''Rupees is
Pakistani Currency'

now it should be divided into parts as under:::>

A2 >> [heading is Thousands] > 15
A3 >> [heading is Five Hundreds] > 01
A4 >> [heading is Hundreds] > 03
A5 >> [heading is Fifty] > 01
A6 >> [heading is Tens] > 01

in this example the amount has been divided into parts that it has
15-notes of Thousand, 1-note of Five-hundred, 3-notes of Hundreds,
1-note of Fifty and 1-note of Ten.

Here is another way...

A1: 15860
A2: =INT(A1/1000)
A3: =INT(MOD(A1,1000)/500)
A4: =INT(MOD(MOD(A1,1000),500)/100)
A5: =INT(MOD(MOD(MOD(A1,1000),500),100)/50)
A6: =MOD(MOD(MOD(MOD(A1,1000),500),100),50)/10

Rick