Barcode Check Digit Formula

Hi guys,

I need a formula to calculate a barcode check digit.

It basically needs to work of the SUM of last four digits.

The check digit will be the smallest number required to round the Sum to the nearest multiple of
10.

so

1234=0
1235=9

lets say the codes are in column A and formula in column B

thanks in advance!

Here, try this:

Formula:

Please Login or Register  to view this content.

Spot on, massive thanks for that.

Exactly what I was after.