if then formula
Try this:
=IF(MOD(A1,60),0,A1)
Biff
"Ann" wrote in message
...
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.
|