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
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"))
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:
- Excel formula
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
1 response
Computertech
Posts
3569
Registration date
Friday February 6, 2015
Status
Moderator
Last seen
July 18, 2016
893
Mar 6, 2015 at 01:52 AM
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 ...
without any data how you use this formula...
You can use this formula with a valid data ...