Validate multiples of a number.

asked 2016-12-30 02:14:36 +0100

Hi all, hope you can help. Have written a cash counting spreadsheet in Excel but have to convert if to libre calc since they don't use ms office suite.

Most of it has converted fine, with a few tweaks, but one of the main validations has disappeared.

When counting bags of coins they should only be entered in multiples i.e. £1 coins come in bags of 20 so the validation should only accept 20, 40, 60, 80...

The way I managed this in excel is :

Use Data / Validation... and choose "Custom" and use the formula:

=INT(A1/20)=A1/20

Where A1 is the entry cell.

I am trying to recreate this in Libre Calc but cant find a way of entering custom formulas, can anyone please advise.

edit retag flag offensive close merge delete