Sum that returns a statement

[slay0r]

Hi All,

I'm calculating the number of days between 2 dates which is really easy, however some of the cells don't have dates in them and I'd like it to return something other than value, maybe "N/A" so we know it's been seen to.

Currently it's just "AS2-AC2" Is there an easy way to do the value?

Kind Regards
Jonathan

 

[FormR]

Hi, here is one option:

=IF(COUNT(AS2,AC2)=2,AS2-AC2,"N/A")

 

[steve the fish]

This maybe:

=IF(2=(ISNUMBER(AS2)+ISNUMBER(AC2)),AS2-AC2,"NA")

 

[steve the fish]

Oh yeah count