J
JillianRuth
The issue I'm having is regarding a monster of a conditional formula I've
written in Excel 2000. It contains a circular reference (not explicitly
within the formula, but in conjunction with another). It is the following:
=IF(ISNA(H30),"Crx",IF(AND(H30<500000,A30="System
B"),"Problem",IF(AND(H30<800000,OR(A30="System C/D",A30="System
E",A30="System F",A30="System G",A30="System
H/I")),"Problem",IF(OR(AND(I28="Problem",E28>VLOOKUP(A28,MoveBe,2)),AND(I29="Problem",E29>VLOOKUP(A29,MoveBe,2)),AND(I31="Problem",E31<VLOOKUP(A31,MoveBe,2))),"Incoming","Just Fine"))))
Now, the problem isn't that the formula doesn't work; when I go to the Edit
Formula button it tells me that the correct answer (in this case, "Just
Fine") is being calculated. The problem is, the actual cell doesn't read
Just Fine, it reads 0.00.
I try to trace error, but according to Excel there is no error. Yet it
won't put my answer in the cell. Any ideas?
written in Excel 2000. It contains a circular reference (not explicitly
within the formula, but in conjunction with another). It is the following:
=IF(ISNA(H30),"Crx",IF(AND(H30<500000,A30="System
B"),"Problem",IF(AND(H30<800000,OR(A30="System C/D",A30="System
E",A30="System F",A30="System G",A30="System
H/I")),"Problem",IF(OR(AND(I28="Problem",E28>VLOOKUP(A28,MoveBe,2)),AND(I29="Problem",E29>VLOOKUP(A29,MoveBe,2)),AND(I31="Problem",E31<VLOOKUP(A31,MoveBe,2))),"Incoming","Just Fine"))))
Now, the problem isn't that the formula doesn't work; when I go to the Edit
Formula button it tells me that the correct answer (in this case, "Just
Fine") is being calculated. The problem is, the actual cell doesn't read
Just Fine, it reads 0.00.
I try to trace error, but according to Excel there is no error. Yet it
won't put my answer in the cell. Any ideas?