Thread: #Value
View Single Post
  #1   Report Post  
Robbyn
 
Posts: n/a
Default #Value

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

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