|
Help with if statement
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 Im 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 |
Help with if statement
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 |
Help with if statement
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 . |
Help with if statement
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 . |
Help with if statement
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 . |
| All times are GMT +1. The time now is 05:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com