Breakdown

A

AJ

If i have a column with totals eg.F5= R450-00; F10= R200; F15= R20-00 etc.

I need to have a breakdown of the denominations below eg.B40=R200 notes must
equal F5 + F10 + if there are any more R200 notes in any other columns which
i add, so in actual fact C40 must then be =3.

Please advise
 
K

kassie

Hi AJ

You can use the following formulae. You can of course replace the SUM()
part with a reference to a total cell, eg F16 wuold then contain =SUM(F5:F15)

in A40 = 200
In B40 = =ROUNDDOWN(SUM(F5:F15)/B40,0)
In A41 = 100
In B41 = =ROUNDDOWN((SUM(F5:F15)-(C40*B40))/B41,0)
In A42 = 50
In B42 = =ROUNDDOWN((SUM(F5:F15)-(C40*B40)-(C41*B41))/B42,0)
In A43 = 20
In B43 = ROUNDDOWN((SUM(F5:F15)-(C40*B40)-(C41*B41)-(C42*B42))/B43,0)
and in A44 = 10
In B44 =
=ROUNDDOWN((SUM(F5:F15)-(C40*B40)-(C41*B41)-(C42*B42)-(C43*B43))/B44,0)

That will give you a breakdown of your denominations in R200, R100, R50, R20
and R10 notes
 
Top