?
Solved

Number must be a multiple of 0.25

Posted on 2011-05-04
3
Medium Priority
?
600 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:mikecharters
  • 2
3 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35695089
Use this validation formula (Custom):

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

Kevin
0
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 2000 total points
ID: 35695100
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
 

Author Comment

by:mikecharters
ID: 35695208
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question