Validation in 1/4's

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
I need some ideas or a solution for this......
I want the users to be able to only enter numbers that are either whole numbers or numbers with decimals .25, .50, .75 or in quarter increments. Any help would be appreciated!!!
thanks!
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
Well I come up with one

=SUMPRODUCT(--(MOD((C2/0.25),4)={0,1,2,3}))

but I would still like to see what others would do in this situation.
thanks,
 

ken2step

Well-known Member
Joined
Jan 9, 2003
Messages
632
Man did I over do it! Thanks Brian the first one Mod(A1,.25)=0 is the ticket for sure. THanks a bunch Man!!!
 

Forum statistics

Threads
1,148,525
Messages
5,747,194
Members
424,068
Latest member
Salim khamis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top