It looks as though some of the cells that are being used for calculation are
not empty, but contain a space " ", which cannot be rounded.


A simple solution to this would be to use the following formula which
checks for the error and saves you having to put 0 in the blank cells

=if(iserr(ROUND(EmployeeData!AM6*(EmployeeData!$P6 *'Emp
Calendar'!F6-'Vacation
Schedule'!I6)*ProgramOverview!$AR6,2))=true,"",ROU ND(EmployeeData!AM6*(EmployeeData!$P6*'Emp Calendar'!F6-'Vacation
Schedule'!I6)*ProgramOverview!$AR6,2))

Richard

"SLP" wrote:

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.