or
orPHP Code:
=NOW()+IF(VLOOKUP(A2;J:K;2)<0;-TIME(ABS(VLOOKUP(A2;J:K;2));0;0);TIME(ABS(VLOOKUP(A2;J:K;2));0;0))
PHP Code:
=NOW()+(2*(VLOOKUP(A2;J:K;2)>0) -1)*TIME(ABS(VLOOKUP(A2;J:K;2));0;0)
or
orPHP Code:
=NOW()+IF(VLOOKUP(A2;J:K;2)<0;-TIME(ABS(VLOOKUP(A2;J:K;2));0;0);TIME(ABS(VLOOKUP(A2;J:K;2));0;0))
PHP Code:
=NOW()+(2*(VLOOKUP(A2;J:K;2)>0) -1)*TIME(ABS(VLOOKUP(A2;J:K;2));0;0)
Last edited by snb; 02-17-2012 at 06:11 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks