Excel. Double the number in cell A7, IF all cells from A1 through A6 contain a value higher than 0.
I am trying to make an excel timesheet where Employees who work on Sunday get paid at double their hourly rate. HOWEVER, in order for them to get this double rate they MUST have worked all of the previous 6 days. (i.e Monday to Saturday) Otherwise they just get the usual hourly rate.
Got myself rather confused!! Any pointers please?!!!