G Guest Feb 9, 2005 #1 =IF(OR(D2>0, E2>0),(Lists!E2+SUM(D2))-SUM(E2),"") How do I avoid the #value error when Lists!e2 is blank?
=IF(OR(D2>0, E2>0),(Lists!E2+SUM(D2))-SUM(E2),"") How do I avoid the #value error when Lists!e2 is blank?
M Max Feb 9, 2005 #2 Try this revised formula instead: =IF(OR(D2>0, E2>0),SUM(Lists!E2,D2)-E2,"") SUM(..) will ignore text Think it was likely to be a stray space entry (made with spacebar) in Lists!E2 which caused the error, rather than the cell being blank
Try this revised formula instead: =IF(OR(D2>0, E2>0),SUM(Lists!E2,D2)-E2,"") SUM(..) will ignore text Think it was likely to be a stray space entry (made with spacebar) in Lists!E2 which caused the error, rather than the cell being blank
G Guest Feb 9, 2005 #3 Thanks much Max! Max said: Try this revised formula instead: =IF(OR(D2>0, E2>0),SUM(Lists!E2,D2)-E2,"") SUM(..) will ignore text Think it was likely to be a stray space entry (made with spacebar) in Lists!E2 which caused the error, rather than the cell being blank Click to expand...
Thanks much Max! Max said: Try this revised formula instead: =IF(OR(D2>0, E2>0),SUM(Lists!E2,D2)-E2,"") SUM(..) will ignore text Think it was likely to be a stray space entry (made with spacebar) in Lists!E2 which caused the error, rather than the cell being blank Click to expand...
