I
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
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