Mulitples
Posted by Stephen Ellis on July 31, 2001 6:17 AM
I need to know how to have excel look at a cell and tell me if it is a mulitple of 40. Does anyone know how to do this. Also I need to know how to put in an error response if the number is not a multiple of 40.
Posted by Aladin Akyurek on July 31, 2001 6:29 AM
=IF(MOD(A1,40)=0,"Multiple","Error: Not a multiple.")
Aladin
