Currency denominator - Dynamic / Pre Calculate the values

Denomination Pieces Amount500 2 1000
200 2 400
100 1 100
50 1 50
20 1 20
10 1 10
---------------------------------------
1580

What I need is to precalculate with the various denomination figures, when I enter numbers (for the pieces) in Amount column. Finally, i will have only one column [Amount], with precalculated value.

Hi Carim,

Thanks for your good job getting this useful. There are a few tweaks needed here.

Each cell be populate with values once entered with number in a individual cell.

for eg., A1 is entered with 2 , it should show 1000

and A2 entered with 1, it should show 200.

A3 with 1, should show 100

A4 with 1, should show 50

till A6.

3. Now B1 entered with 4, should show 1000

B2 entered with 2, should show 400

till B6.

4. For C1 to C6

till Z1 to Z6. once the individual cell is entered with number.

Pl refer sheet2 of the attachment.

Hi Carim,

Fantastic. Awesome Job.