Is this possible in Calc/Excel? (calculate how much of each denomination to give / money)

[AceyWolf]

Is it possible to have Calc/Excel calculate how much of each denomination to give?

I have 4 cells, “To pay”, 20s, 10s, 1s.

For example, if I was to enter £250 in a A1, could excel/calc automatically calculate and fill cells of how much of each denomination to give? So when entering 250, excel/calc would do 20s = 240, 10s = 10s, 1s = 0.

[EarnestAl]

I used integers INT() finishing with ROUND(). You didn’t say what to do with fractions of a s. so I rounded. I did a first calculation by amount, the second by count of notes
ChangeByDenomination.ods (11.2 KB)

[AceyWolf]

This is perfect, thank you very much.
It’s exactly what I was looking for!