IF function - need FALSE to return a blank cell, not 0

[Guest]

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

 

[Bondi]

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

Hi Maestro,

You can not get a completely blank cell as a result of a formula. You
can get one that shows nothing with something like:
=IF(a2=value,process,"")

Regards,
Bondi