Good afternoon all

I work in a printing company and we have a job which has 12 versions of stationery, which prints 4up on a sheet. Where the quantities are not exactly divisible by 4, then it prints "Filler Records" for the rest of the sheet. So for example if I had 5 records, I would get 3 filler records (1 full sheet of 4, and 1 sheet with only 1 quarter filled). This is causing problems though so need to come up with a formula to aid them when cutting the paper.

So far I have =MOD(B194,4), and this gives me the remainder, but what I actually need it to tell me how many filler records there would be, so this sum, then subtract from 4 unless it is zero. Below may help in trying to explain what I am after?

Records Total Number of Sheets Qty of Filler Records
5 2 3
6 2 2
7 2 1
8 2 0
9 3 3
10 3 2

Thanks in advance.

Craig Kinsey