#Value

R

Robbyn

=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

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
 
R

Robbyn

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I assign "Apple" to a cell reference in this evaluate code? 2
Adding cells until they are greater than a lookup cell and returning a value 1
Using <= in countifs statement 1
Help with calculating time and a half - I've got straight time and double time. 4
calulation 1
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Copying formulas across columns 2
Conditional sum, when condition has multiple values 3

Top