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.

if then formula
 

=if(mod(a1,60)=0,a1,0)
or equivalently
=a1*(mod(a1,60)=0)

Ann wrote:

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.

--

Dave Peterson

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.

if then formula
 

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.

if then formula
 

Try this entered in B1

=IF(INT(A1/60=INT(A1/60)),A1,0)


Gord Dibben MS Excel MVP


On Mon, 25 Jun 2007 14:22:00 -0700, Ann wrote:

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.

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.