Display cell blank with formula in it

[kevinc1973]

Hello everyone,
I have a formula that uses 3 cells to calculate average for each machine, I have 3 machines and not all machines run each day and 1 of cells for each machine has the same number whether it runs or not. Is there a way to show the cell blank if 2 out of 3 cells its looking at are blank? If one of the machines doesn't run it shows a #value! in the cell.
Thanks in advance
Kevin

 

[Anthony47]

Which is the formula? Or simply use IFERROR:

=IFERROR(YourFormula,"")

Bye

 

[kevinc1973]

Which is the formula? Or simply use IFERROR:

=IFERROR(YourFormula,"")

Bye

Thanks I will try when I get to work tomorrow night.

 

[Peter_SSs]

Without knowing your particular circumstances, it is possible that using IFERROR may hide other errors that you would want to know about. You could use something like this to directly check that at least 2 of the 3 cells contain numbers.

22 01 30.xlsm
	A	B	C	D
1
2			6
3
Check Cells

Cell Formulas
Range	Formula
D3	D3	=IF(COUNT(A1,B3,C2)<2,"",A1+B3+C2)

 

[kevinc1973]

Without knowing your particular circumstances, it is possible that using IFERROR may hide other errors that you would want to know about. You could use something like this to directly check that at least 2 of the 3 cells contain numbers.

22 01 30.xlsm
	A	B	C	D
1
2			6
3
Check Cells

Cell Formulas
Range	Formula
D3	D3	=IF(COUNT(A1,B3,C2)<2,"",A1+B3+C2)

Thanks that worked perfect

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.