Trouble Using Nested IF Formula

[scottmcclean]

Hi all,
I am trying (unsuccessfully) to create an IF statement that does the following:

In cell S2 If The week number in H2 is Greater than Todays date then write "Late" If not write nothing, If H2 has nothing in it then keep the cell (S2) blank.

I am probably way off but I tried the following: IF(H2<$T$1, "Late", IF(H2="","")). I would appreciate any assistance!

Many thanks

 

[RudiS]

Try this:
= IF(H2="","",IF(H2>WEEKNUM($T$1), "Late",""))

 

[scottmcclean]

Try this:
= IF(H2="","",IF(H2>WEEKNUM($T$1), "Late",""))

Genius!
Thank you so much - it works a treat.