I have a very long formula that depends on other cells to be filled in before
it shows a value. When those cells are not filled in, the #VALUE! error
appears. That error effects the rest of the sheet as it is needed for other
cells to work properly.

I saw someone posted:

=IF(ISERROR(your_formula),"",your_formula)

When I entered my formula, it told me there was an error in that formula,
which of course meant my problem wasnt fixed.

Any help would be appreaciated

The formula that you have posted appears fine so I suspect the problem is
with 'your_formula'. What is this??

"A_Cayce" wrote:

I have a very long formula that depends on other cells to be filled in before
it shows a value. When those cells are not filled in, the #VALUE! error
appears. That error effects the rest of the sheet as it is needed for other
cells to work properly.

I saw someone posted:

=IF(ISERROR(your_formula),"",your_formula)

When I entered my formula, it told me there was an error in that formula,
which of course meant my problem wasnt fixed.

Any help would be appreaciated

=IF(AND(AA20,AC2=0,AE2=0),ROUND(AA2,4),IF(AND(AA2 =0,AC20,AE2=0),ROUND(AC2,4),IF(AND(AA2=0,AC2=0,AE 20),ROUND(AE2,4),IF(AND(AA20,AC20,AE2=0),ROUND( AA2*$AA$38+AC2*$AC$38+1*$AE$38,4),IF(AND(AA20,AC2 =0,AE20),ROUND(AA2*$AA$38+1*$AC$38+AE2*$AE$38,4), IF(AND(AA2=0,AC20,AE20),ROUND(1*$AA$38+AC2*$AC$3 8+AE2*$AE$38,4),IF(AND(AA20,AC20,AE20),ROUND(AA 2*$AA$38+AC2*$AC$38+AE2*$AE$38,4),"
")))))))

That is my formula. This is going on a grading sheet, so it is looking at a
few other cells, averaging them and giving them different weight values.

If I enter data into the cells AA2, AC2 an AE2, the #VALUE! error goes away
and it shows what the grade should be.

I am just trying to make the final cell AG2 (the one that shows the error)
appear empty. There are other cells that require that cell to look empty.

Hopefully that makes sense.

"Dan" wrote:

The formula that you have posted appears fine so I suspect the problem is
with 'your_formula'. What is this??

"A_Cayce" wrote:

I have a very long formula that depends on other cells to be filled in before
it shows a value. When those cells are not filled in, the #VALUE! error
appears. That error effects the rest of the sheet as it is needed for other
cells to work properly.

I saw someone posted:

=IF(ISERROR(your_formula),"",your_formula)

When I entered my formula, it told me there was an error in that formula,
which of course meant my problem wasnt fixed.

Any help would be appreaciated