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
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~(-:
---
PLUG-
