I need the cell to be blank instead of showing #DIV/0!

[Iain]

Hi there
I just need a quick bit of advice on how to get a cell to be blank instead
of showing the above error whenever no data is entered in a selected cell
range.

The formula i'm using is something like
=Sumproduct(C1:C4,D14)/F1
I've tried the IF rule but it only works on the first set, but not on the
second set, it starts returning #Value!
Formula used was
=IF(C1:C4="","",Sumproduct(C1:C4,D14)/F1)
The above formula did return a blank cell untill data entered in the first
range.
But when i moved on to the next formula it returned #VALUE!
The formula i tried was the same but in the next set of cells down.
=IF(C5:C8="","",Sumproduct(C5:C8,D58)/F2)

Can anyone who understands what i've just said please help.

Many thanks
Iain

 

[Dave]

Hi,
Try:
=IF(ISNA(=Sumproduct(C1:C4,D14)/F1),"",Sumproduct(C1:C4,D14)/F1)
Regards - Dave

 

[Dave Peterson]

#div/0! means that you're trying to divide by 0.

So maybe:

=if(f1=0,"",Sumproduct(C1:C4,D14)/F1)
or
=if(f1=0,"whatyouwanthere",Sumproduct(C1:C4,D14)/F1)

 

[Dave]

Oops,
I mean:
=IF(ISERR(=Sumproduct(C1:C4,D14)/F1),"",Sumproduct(C1:C4,D14)/F1)

Dave.

 

[Iain]

Thanks guys will give that a try tomorrow at work and see if it works out ,
i'll post the result tomorrow night

Kind Regards
Iain

 

[Iain]

Thanks guys it worked well.