G Guest Aug 5, 2004 #1 How can I restraint the user from entering odd numbers in the cell? But I need the outcome to be in multiples of 5? Thanks. Ringo Tan
How can I restraint the user from entering odd numbers in the cell? But I need the outcome to be in multiples of 5? Thanks. Ringo Tan
J JE McGimpsey Aug 5, 2004 #2 So you want to restrict entries to even multiples of 5? Assuming your input cell is A1: Allow: Custom Formula: =MOD(A1,10)=0
So you want to restrict entries to even multiples of 5? Assuming your input cell is A1: Allow: Custom Formula: =MOD(A1,10)=0
J JulieD Aug 5, 2004 #3 or do you, once the person has entered the (even) number round the number to the nearest multiple of 5? if so, you can't do this in the same cell without using some VBA code. please clarify if this is what you want Regards JulieD ringo tan said: How can I restraint the user from entering odd numbers in the cell? But I Click to expand... need the outcome to be in multiples of 5?
or do you, once the person has entered the (even) number round the number to the nearest multiple of 5? if so, you can't do this in the same cell without using some VBA code. please clarify if this is what you want Regards JulieD ringo tan said: How can I restraint the user from entering odd numbers in the cell? But I Click to expand... need the outcome to be in multiples of 5?
