View Single Post
  #4   Report Post  
Coddie
 
Posts: n/a
Default

Yes! It was exactly what I needed. Thank you for your time and assistance.

Coddie

"Harlan Grove" wrote:

"Ola" wrote...
Do you mean? :

=IF(OR(ISNUMBER(A3),ISNUMBER(A2),ISNUMBER(A1)), A3-A2+A1,"")
'AND' instead of 'OR' if all cells must be numbers.


Alternatively, 'OR' semantics:
=IF(COUNT(A1:A3)=1,A3-A2+A1,"")

'AND' semantice:
=IF(COUNT(A1:A3)=3,A3-A2+A1,"")