Solved

Number must be a multiple of 0.25

Posted on 2011-05-04
356 Views
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
Question by:mikecharters

LVL 81

Expert Comment

Use this validation formula (Custom):

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

Kevin
0

LVL 81

Accepted Solution

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

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

Join & Write a Comment Already a member? Login.

Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

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

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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!