Validating Cells

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

In one column of our spreadsheets I need to have users
enter only numbers divisible by 45. I am not sure what I
should be using to validate if the entry is correct. Can
anyone help?

Thanks
 
Hi
one way:
- Select the column (lets say column A)
- goto 'Data - Validation'
- enter the formula:
=MOD(A1,45)=0
 
Hi Carol

choose cell (eg A1)
choose Data / Validation
choose Custom
enter
=Mod(a1,45)=0
copy down to other cells

Cheers
JulieD
 
-----Original Message-----
In one column of our spreadsheets I need to have users
enter only numbers divisible by 45. I am not sure what I
should be using to validate if the entry is correct. Can
anyone help?

Thanks
.
I guess that you know how to do a validation. In the cell
Click to expand...
the validation is to occur. go Data/tools/validation,
decide if you want to restrict or warn if not ok, choose
custom, enterformula =mod(cell address,45)=0. I tried it
and it worked.Good luck

Luke
(e-mail address removed)
 
Back
Top