Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding error
How can I restrict a cell so that it will only accept whole numbers between 1
and 24, or a decimal number between .25 and 23.75? The decimal answers can only be .25, .5 or .75? -- Thanks Shawn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
rounding error
Shawn,
in the data validation select 'custom' and in the formula type =AND(4*A10, 4*A1<=96,4*A1=INT(4*A1)) This formula applies to cell A1. You will need to extrapolate for other cells. Good luck Fred "Shawn" wrote in message ... How can I restrict a cell so that it will only accept whole numbers between 1 and 24, or a decimal number between .25 and 23.75? The decimal answers can only be .25, .5 or .75? -- Thanks Shawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rounding error | Excel Discussion (Misc queries) | |||
rounding error? | Excel Discussion (Misc queries) | |||
ROUNDing on a MAC - conversion error | Excel Programming | |||
Is this rounding error? | Excel Programming | |||
Rounding Error | Excel Programming |