Re: NESTED IF STATEMENT USING DATE

Thank you Mike. With a slight correction it worked.

SJ
"Mike H" <MikeH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1E8C4544-B45D-4B70-AF3F-0338BA5F97F4@xxxxxxxxxxxxxxxx
Try

=IF(TEXT(D2,"yyyy")="2007",2007,IF(TEXT(A13,"yyyy")="2006",2006,2005 & "
Before"))

Mike

"SSJ" wrote:

Hello!

Can some review the following IF statement. The error is stating that
there are too many arguments.

=IF((TEXT((D2),"yyyy")="2007"),"2007",if(TEXT(d2),"yyyy")="2006","2006","2005
& Before")



If the year of the date is 2007, state "2007", If the year of the date is
2006, state "2006", otherwise state "2005 & Before"



Thanks in advance



SJ



.

Relevant Pages

  • Re: Beethovens Late Quartets - Colorado SQ.
    ... Fanfare. ... she reviewed the recent Pristine Audio ... She began by stating that although she'd heard about the ... review. ...
    (rec.music.classical.recordings)
  • Re: Beethovens Late Quartets - Colorado SQ.
    ... she reviewed the recent Pristine Audio ... She began by stating that although she'd heard about ... Then -- at the end of her review ... Fanfare needs to clarify. ...
    (rec.music.classical.recordings)
  • Re: Digital Switchover dates
    ... showing the most likely dates and channels. ...
    (uk.tech.digital-tv)
  • Re: Beethovens Late Quartets - Colorado SQ.
    ... Fanfare. ... she reviewed the recent Pristine Audio ... She began by stating that although she'd heard about the ... read the whole review and amend the beginning before it is sent out. ...
    (rec.music.classical.recordings)
  • Re: Thoughts on Lucifers Call
    ... I came across a review somewhere stating that: ... carried all too familiar rpg flaws" ... highly praised rpgs, yet without a smidgen of LC orignial ideas. ...
    (uk.games.video.playstation)