Guidance expected in the IF formula

[Ajinkya]

Dear Friends,


Please guide in formula...


A2=N

B2=C

C2=L

D2=-2

E2={=IF($A2="N",IF($B2="C",IF($C2="L",IF($D2<0,CHAR(252)," ")," ")))}


Here i wanted to add one more condition for value of cell C2

because it is flexible, here some times "Null" aslo comes insted of "L"


please suggest in the formula to get desired result.


Rgds,

Ajinkya

 

[Faseeh]

Hi Ajinkya,


If you want same result for C2 = L or C2 = Null then you need to add an OR() statement in the Third IF() like this:

=IF($A2="N",IF($B2="C",IF(OR(C2="L",C2="Null"),IF($D2<0,CHAR(252)," ")," ")))

..hope that works for you.


Regards,

 

[Ajinkya]

Thanks dude, it works also thanks for discription also

 

[Faseeh]

You are welcome!

 

[shrivallabha]

Does this work [few cases like only A2 filled could be problem though]:


=IF(ISNUMBER(FIND(A2&B2&C2,"NCL",1)),CHAR(252),"")

 

[Guest]

Then strong arms, Luo edge to bed, all of a sudden thrown into the bed and said: little beauty, although we do not know the boss so we caught you to what purpose, however, we are, after all, can be considered old acquaintance, right? when at the airport,walter, to see you and your boyfriend, lingering look, also really like romance drama out of the I want to heat it in fact, wives,fitch, you find you like good, nice, gentle, hey, it seems pretty good figure, importantly, without any effort,lou, no resistance capacity, Luo edge eyes wide, looked amazing front man