IF statement for blank cell with hidden formula

[JFITZ138]

Hi

I want to return a cell (U930) blank if another cell is <>0 e.g.

Formula in U930 =IF(U490<>0,AVERAGE(O490:U490),"")

U490 is blank, however has a similar formula which leaves it blank.

This formula therefore returns #DIV/0! in U930

This there anyway around this so that U930 will be blank if U490 is. Even if U490 has a formula in the background?

Many Thanks

John

 

[Joe4]

Try this instead:

=IF(LEN(U490)>0,AVERAGE(O490:U490),"")

 

[JFITZ138]

Thanks Joe