Thread: Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Question

=mod(A1,48) returns the remainder when the value in A1 is divided by 48;
gives zero if exactly divisible.
=IF(mod(A1,48),"Not divisible",")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
Is there any way to find out if a particular cell is divisible by 48
(i.e 4 ft)?