#Value
 

=IF(OR(D20, E20),(Lists!E2+SUM(D2))-SUM(E2),"")

How do I avoid the #value error when Lists!e2 is blank?

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?

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?

You're welcome !
Thanks for the feedback
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Robbyn" wrote in message
...
Thanks much Max!