Number must be a multiple of 0.25

Posted on 2011-05-04
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.
Question by:mikecharters
    LVL 81

    Expert Comment

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


    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:


    replacing A1 with the cell address selected. Click OK.


    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

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    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.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now