I have cells containing employee names, production hours per job and
produciton quantities per job for multiple jobs. I need a function to read
the production hours cell and
1. process a formula is there is a value (TRUE)
2. return a blank cell, rather than zero is there is no value (FALSE)
My ultimate goal is to generate an average productivity % across multiple
jobs and multiple employees.

Example:
Name Hrs/job 1 Parts Hrs/Job 2 Parts Prod.% Job 1 Prod.% Job 2
Avg. Prod
Joe 4 10 75%
<blank 75%
Mary 4 20 <blank
100% 100%

Any help will be greatly appreciated!

Thanks. Maestro