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.
|