if then formula
You're welcome. Thanks for the feedback!
Biff
"Ann" wrote in message
...
perfect, that worked! thanks again
"T. Valko" wrote:
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.
|