So, I tried this one, but it returns FALSE statement.
=IF(COUNTIFS(ATMS!B:B,$G70,ATMS!H:H,"G450RF",ATMS!M:M,"MM/DD/YYYY HH:MM/SS"),IF(COUNTIFS(ATMS!B:B,$G70,ATMS!H:H,"G450RF",ATMS!M:M,"MM/DD/YYYY HH:MM:SS"),"MM/DD/YYYY HH:MM:SS","NONE"))
So, I tried this one, but it returns FALSE statement.
=IF(COUNTIFS(ATMS!B:B,$G70,ATMS!H:H,"G450RF",ATMS!M:M,"MM/DD/YYYY HH:MM/SS"),IF(COUNTIFS(ATMS!B:B,$G70,ATMS!H:H,"G450RF",ATMS!M:M,"MM/DD/YYYY HH:MM:SS"),"MM/DD/YYYY HH:MM:SS","NONE"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks