Data Validation with two criteria

Hi guys

Restaurant managers in our business can order five-pound note's to be used as change in their tills

Every week they fill out a form and email it to me. I save each file to my hard drive then auto populate a master sheet which I then send to the bank for processing

On the sheet the managers use, I need to set data validation so that they only order five pound note's that meet two criteria. These are

'must be in multiples of £100'
'must be minimum £500'
'user still needs to be able to enter zero' (for use when they don't want any five's)

I have used data validation > custom validation > formula "=MOD(D16,100)=0"
This triggers a warning if the user does not enter a multiple of £100

I am stuck on how to join a string of formula that will enforce the criteria 'no entries between 1-499'


Can anyone help? Im desperate!



loveyouall

Almost but using that I can't enter zero

Thanks for such a quick response to my original post : )

Perhaps it would be easier to just allow the values 0, 500, 600, 700, 800, 900 and 1000?

That's absolutely perfect! Thank you so much : )


There is no limit on how many five's they can order, its just very very unlikely they would ever need more than 1000 so we could of set it as a max if it made writing the formula any easier. The provided solution works perfectly so we can ignore that

Thanks again!