MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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