Help needed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shakeel Ahmad - 12 Jun 2007 15:29 GMT

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.

Reply to this Message

JE McGimpsey - 12 Jun 2007 15:43 GMT

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)

> Please Help me in the following ::
>
[quoted text clipped - 14 lines]
>
> how can i do this, help please.

Reply to this Message

Andy - 12 Jun 2007 16:02 GMT

> Please Help me in the following ::
>
[quoted text clipped - 14 lines]
>
> 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

Reply to this Message

Rick Rothstein (MVP - VB) - 12 Jun 2007 16:35 GMT

> For Example in Cell A1 I write (15860) Rupees '''Rupees is
> Pakistani Currency'
[quoted text clipped - 10 lines]
> 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

Reply to this Message

Shakeel Ahmad - 16 Jun 2007 15:33 GMT

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'
[quoted text clipped - 21 lines]
>
> Rick

Reply to this Message

Ron Rosenfeld - 12 Jun 2007 16:47 GMT

>Please Help me in the following ::
>
[quoted text clipped - 14 lines]
>
>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

Reply to this Message

Rate this thread: