Good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"rew3791" wrote in message
...
Ignore the last post. I think it's working! Thanks!

--
Rachel


"rew3791" wrote:

I got "True" in each row.


--
Rachel


"T. Valko" wrote:

Try this...

=IF(COUNT(D3:E3)=2,E3-D3,IF(COUNT(D3:E3),IF(D3="",E3-100,IF(E3="",D3+100,"")),""))

--
Biff
Microsoft Excel MVP


"rew3791" wrote in message
...
Ok, I can't quite make this formulat work.
Assume: Column D is Birth Year, Column E is Death Year, Column F is
Age at
Death

The basic formula is =E-D (Death Year minus birth year gives me age
at
death
(F))

What I'm trying to do is if the death year column is blank (E), add
100 to
the birth year (D), then use that number as the E in the basic
formula.
Similarly, if the birth year column (D) is blank, subtract 100 from
the
death
year (E) then use that as D in the =E-D formula.

This is the statement I've tried:
=IF(ISBLANK(E3), (E3=D3+100)), IF(ISBLANK(D3), (D3=E3-100)), E3-D3

Those "=" signs don't look right....I think that's part of it.
Help?! Thank you!!!!!

--
Rachel


.