Another If Nesting Problem

[kiki443]

I have a few columns and I want the final column to do a calculation based on certain criteria.

Ex.:

col. 1 col. 2 col. 3 col.4
dog 4/20/06 5/20/06 =if(a2,dog,(today()-b2,if(a2,cat,(c2-b2,"")
cat 6/10/06 8/12/06
fish 6/30/06 7/15/06

I want the formulat in col. 4 to capture all available options.

Is this possible to do?

Thanks

 

[Andrew Fergus]

Hi

If we take your example literally then you almost had it - it looks like a syntax issue. For example, is this what you want?

=IF(A2="dog",TODAY()-B2,IF(A2="cat",C2-B2,""))

If this isn't right, can you explain what you want to do?

Andrew