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

Excel formula
Excel date format dd.mm.yyyy - Guide
Number to words in excel formula - Guide
Mark sheet grade formula in excel download - Guide
Transfer data from one excel worksheet to another automatically - Guide
Formula bar in excel missing - Guide

1 reply

Answer 1 / 1

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

How to calculate position (1st,2nd,3rd) in excel....?

formulas for 1st and 2nd position in class

Calculation of positions in excel

Use of '@' in formulae

Similar discussions

Subscribe To Our Newsletter!