Previous Topic Next Topic

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"))

1 response

Answer 1 / 1
Computertech Posts 3569 Registration date Friday February 6, 2015 Status Moderator Last seen July 18, 2016 893
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 ...

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses