Formula not consistent
Hi. I'm stumped. I have a formula:
=ROUND(EmployeeData!AM6*(EmployeeData!$P6*'Emp Calendar'!F6-'Vacation
Schedule'!I6)*ProgramOverview!$AR6,2)
Sometimes I works fine and other times I have to go to the VacationSchedule
sheet and enter a zero when there isn't a number in the cell in order to not
have the #Value error show.
Any ideas what it could be? Thanks.
|