Thanks much Max!
"Max" wrote:
Try this revised formula instead:
=IF(OR(D20, E20),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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Robbyn" wrote in message
...
=IF(OR(D20, E20),(Lists!E2+SUM(D2))-SUM(E2),"")
How do I avoid the #value error when Lists!e2 is blank?
|