Number must be a multiple of 0.25

Is there a simple way in Excel to force a particular cell to be divisible by 4 otherwise it will bring up a "DataValidation" error to say that the amount entered must end in 0.25, 0.5 or 0.75 if a decimal amount is entered.
uworldsAsked:
Who is Participating?
 
zorvek (Kevin Jones)ConsultantCommented:
To enter a custom validation formula in Excel 2003 or earlier, select the cell to be validated, choose the menu command Data->Validation, select Allow: Custom, enter this formula:

   =$A$1-ROUND(4*$A$1,0)/4=0

replacing A1 with the cell address selected. Click OK.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
Use this validation formula (Custom):

   =$A$1-ROUND(4*$A$1,0)/4=0

Kevin
0
 
uworldsAuthor Commented:
THANK YOU Kevin this worked perfectly and I can't tell you how much time it is going to save me in future!   You superstar, made my week you have no idea.
Cheers, Mike
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.