Dec 06 2021 06:25 PM
I am creating a spreadsheet that calculates tips based on hours worked and have a table with both AM and PM shifts with the below formula- (Total AM tips(L5)/Total AM hours(I32))*Employee's hours worked (I12) + (Total PM tips(L6)/Total PM hours(J32))*Employee's hours worked(J12)
=IFERROR((($L$5/$I$32)*I12)+(($L$6/$J$32)*J12),0)
I am not getting an error message, but am not getting any data unless I have hours worked in both the AM Hours (I) & PM Hours (J) columns. I would like the formula to calculate even if there is no data for the AM formula - as we are not always open for lunch and would like to be able to leave cells blanks on those days.
Dec 06 2021 06:44 PM
SolutionDec 06 2021 06:47 PM
Dec 06 2021 06:44 PM
Solution