I fixed it. I wish they would pay attention to math rules! I got it to work like this: =ROUNDDOWN(((D365-C365)*($N$125)*0.01)*1.5+(((F365-E365)*0.01*($P$125))*1.5),2) On Fri, Mar 3, 2023 at 11:41 AM Michael wrote: > here is my formula: > > =ROUNDDOWN(((D191-C191)*($N$125)*0.01+((F191-E191)*0.01*($P$125))*1.5),2) > > when I plug in 0ne hour of time it gives me straight pay, not the holiday > pay of 1.5 times what, pray tell, have I done wrong? > > > -- > :-)~MIKE~(-: > -- :-)~MIKE~(-: