To achieve the Yes/No answer, you may use the 'IF' function to test the value in the cell. For example:
=IF(MOD(A1,3)=0,"YES","NO")
This equation reads: If the value in cell A1, when divided by 3, leaves a remainder of 0, then display "Yes", otherwise display "No". I only use the 'MOD' function because it is shorter. You may test for Denny's example as well.
Denny Denham
2 Intern
•
18.8K Posts
0
November 21st, 2003 03:00
If the value to be tested is in cell Ax use the formula:
=NOT(Ax/3<>(INT(Ax/3)))
This will return FALSE if Ax is not divisible by 3 and TRUE if it is.
firstclermont
30 Posts
0
November 21st, 2003 13:00
jaystevenson:
To achieve the Yes/No answer, you may use the 'IF' function to test the value in the cell. For example:
=IF(MOD(A1,3)=0,"YES","NO")
This equation reads: If the value in cell A1, when divided by 3, leaves a remainder of 0, then display "Yes", otherwise display "No". I only use the 'MOD' function because it is shorter. You may test for Denny's example as well.
Denny Denham
2 Intern
•
18.8K Posts
0
November 21st, 2003 15:00
I like your function better. Mine was rooted in Fortran IV with a sprinkling of Quattro Pro.