Hi,
Same formula using, why error #NUM! was appear?
TEXT(MAX(IF(A351:A356=C355&1,B351:B356)),"dd.mm.yyyy")
Correct result
TEXT(MAX(IF('FD '!A:A='Welfare AN'!B9&2,'FD '!B:B)),"dd.mm.yyyy")
Result = #NUM!
Thanks
Hi,
Same formula using, why error #NUM! was appear?
TEXT(MAX(IF(A351:A356=C355&1,B351:B356)),"dd.mm.yyyy")
Correct result
TEXT(MAX(IF('FD '!A:A='Welfare AN'!B9&2,'FD '!B:B)),"dd.mm.yyyy")
Result = #NUM!
Thanks
Last edited by Shermaine2010; 08-21-2011 at 03:45 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks