*** VD 15 Commentary Thread ***

[heyelander]

the spreadsheet is missing, but there's a draft history paste down below.

wait, I know I was looking at it... maybe I was looking at V?

[frae]

Good to see we are drafting on Amish time already.

[heyelander]

wait, I know I was looking at it... maybe I was looking at V?

yeah, I was looking at V.

[johnnya24]

yeah, I was looking at V.

Yeah VD V, VD XIII is missing in action.

[revo]

Since I see the Contemporary era has changed to now be 1999-2004, how would I change that formula on my spreadsheet? Here's what I have:

=IF(g4<=1898,"Deadball", IF(h4>=1999,"Contemp"," "))

[heyelander]

Since I see the Contemporary era has changed to now be 1999-2004, how would I change that formula on my spreadsheet? Here's what I have:

=IF(g4<=1898,"Deadball", IF(h4>=1999,"Contemp"," "))

try
=IF(g4<=1898,"Deadball", IF(h4>=1999,if(h4 <= 2004, "Contemp"," "," ")))

[Ken]

try
=IF(g4<=1898,"Deadball", IF(h4>=1999,if(h4 <= 2004, "Contemp"," "," ")))

overly complex. Use the and.

=IF(g4<=1898,"Deadball", IF(and(h4>=1999, h4<=1999),"Contemp"," "))

[heyelander]

overly complex. Use the and.

=IF(g4<=1898,"Deadball", IF(and(h4>=1999, h4<=1999),"Contemp"," "))

ah, nice... I need to use the and more.

[frae]

So Mookie knows he is up? Has he posted anywhere?

[johnnya24]

So Mookie knows he is up? Has he posted anywhere?

Pretty sure he knows we've started. Haven't spoke to him in a couple of days. Already messaged him.

[Bene Futuis]

All right, find the bag....

[revo]

overly complex. Use the and.

=IF(g4<=1898,"Deadball", IF(and(h4>=1999, h4<=1999),"Contemp"," "))

That doesn't work. For a player where it should show up as "Contemp" it comes up blank.

[cavebird]

I think the second 1999 should be 2004, but have no clue beyond that.

[revo]

I think the second 1999 should be 2004, but have no clue beyond that.

Nope, that doesn't work either.

[Ken]

Nope, that doesn't work either.

This shouldn't be so hard, but I'm a little in the blind without your full sheet

what are G4 and H4? It is possible that this needs to be the formula

=IF(g4<=1898,"Deadball", IF(and(h4>=1999, g4<=2004),"Contemp"," "))