mardi 14 juin 2016

Excel IF Statement (linking to other workbook)

Anyone know why this If statement isn't working?

=IF((('http://sharepoint/sites/00000/Testing/[Tested.xls]TEXT(Tested'!D3:D1000,"mm/dd/yyyy")=TODAY()), 'http://sharepoint/sites/00000/Testing/[Tested.xls]Tested'!B3:B1000)

Aucun commentaire:

Enregistrer un commentaire