I want to get the average of 3 numbers.When only one number is given I want the cell for the average to remain blank. What must I do?

Assuming you're talking about Microsoft Excel: =IF((IF(A1>0,10,0))+(IF(B1>0,10,0))+(IF(C1>0,10,0))=30, ((A1+B1+C1)/3), 0)

A1, B1 and C1 are the cells I want the average of. I am also assuming you're only averaging 3 cells.

You could also do something like: =IF(COUNTBLANK(A1:A3)>=2,"",AVERAGE(A1:A3))

Provided that the cell is actually BLANK, and NOT a Zero.

If you are using Zeros, then this

=IF(COUNTIF(A1:A3,0)>=2,"",AVERAGE(A1:A3))

MIKE

Why does your subject line mention the ROUND function? Nothing in your question mentions ROUND.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll