Thread: if then formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default if then formula

my logic isn't working here. i have if a1=multiple of 60, then return a1
otherwise return 0. can i do a "multiple of 60? - for example 60, 120, 180
etc...or i can hard code these since it's only up to 360.