Excel formula

Closed
Simran - Mar 6, 2015 at 01:26 AM
Computertech Posts 3569 Registration date Friday February 6, 2015 Status Moderator Last seen July 18, 2016 - Mar 6, 2015 at 01:52 AM
Hello,
I want the answer of this formula



=IF(AND(L13<$C$1,I13<$C$1,N13<$C$1,P13<$C$1,R13<$C$1,T13<$C$1),"Yes",IF(OR(L13<$C$1,IF(I13=0,0,IF(I13<$C$1,1,0)),IF(N13=0,0,IF(N13<$C$1,1,0)),IF(P13=0,0,IF(P13<$C$1,1,0)),IF(R13=0,0,IF(R13<$C$1,1,0)),IF(T13=0,0,IF(T13<$C$1,1,0))),"Research Required","No"))
Related:

1 response

Computertech Posts 3569 Registration date Friday February 6, 2015 Status Moderator Last seen July 18, 2016 892
Mar 6, 2015 at 01:52 AM
Hello,
without any data how you use this formula...
You can use this formula with a valid data ...
0