Thread: Question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Question

Maybe this will help...........

=IF((A1*12)/48-INT((A1*12)/48)=0,"Yes","No")

Vaya con Dios,
Chuck, CABGx3



" wrote:

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