All,
Thank you in advance for helping with this simple issue that for some reason has me stumped.
=IF($G259<>,(DATE(YEAR($G259)+$H259,MONTH($G259),DAY($G259)-1))),IF(G$259="",($F259<>(DATE(YEAR($F259)+$H259,MONTH($F259),DAY($F259)-1)))
This is my formula, I basically want it to say:
If G259 isn't blank then do the sum G259 + H259 (2), if G259 is blank then look at F259, if F259 isn't blank then do F259 + H259 (2), then if F259 and G259 is blank, then blank.
Ideas?
pls attach a sample excel file with some example and expected result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
It's looking at dates.
All 3 cells will be a date or blank, the returned figure will be the sum of the date in either F259 or G259 + 2 years.
=if(g259<>"",edate(g259,h259*12),if(f259<>"",edate(f259,h259*12),""))
=IF($g259<>"",(date(year($g259).... etc.Originally Posted by NickT83
Just missing a tiny bit, I think.
Oh! I get it.
I need rep--->҉
Old4xford - thanks, still doesn't work but I can't see why not.
nflsales - thanks, does work but H259 is a variable (in this instance 2) and has to be day minus 1, hence the date formula way of working. Any idea why this formula isn't right?
=IF($G259<>"",(DATE(YEAR($G259)+$H259,MONTH($G259),DAY($G259)-1))),IF(G$259="",($F259<>"",(DATE(YEAR($F259)+$H259,MONTH($F259),DAY($F259)-1)))
why you are not attaching a sample excel file
Information is too confidential and I haven't time to amend to suit. I'll fix it myself.
Test page.xls
Hi nflsales, hopefully this will help you.
=IF($G259<>,(DATE(YEAR($G259)+$H259,MONTH($G259),DAY($G259)-1))),IF(G$259="",($F259<>(DATE(YEAR($F259)+$H259,MONTH($F259),DAY($F259)-1)))
Remove the red )
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Thanks, it still doesn't work
Did you tried it?
Please Login or Register to view this content.
In your example it worked for me.
I still get a message saying the formula I typed contains an error.
and what is the result (in your example), if you accept the (by Excel) suggested changes?
There are no suggested changes, it's just a generic error message saying:
For information press help.
To get assistance press function wizard.
If you are not entering a formula then avoid starting with an = or -.
And you did remove the red ) in my formula in #10?
I did, yes.
See the attached file.
Please post the english version on the forum.
Legend. That works perfectly!
Please post the english version (formula) on the forum.
=if($g2<>"",(date(year($g2)+$h2,month($g2),day($g2)-1)),if($f2<>"",(date(year($f2)+$h2,month($f2),day($f2)-1)),""))
This wasn't marked [SOLVED], so I'm guessing it's still an open issue:
=IF($g259<>"",(date(year($g259).... etc.
Just missing a tiny bit, I think.A Combination of the Two works just fine on the example given.=IF($G259<>,(DATE(YEAR($G259)+$H259,MONTH($G259),DAY($G259)-1))),IF(G$259="",($F259<>(DATE(YEAR($F259)+$H259,MONTH($F259),DAY($F259)-1)))
Remove the red )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks