• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IF Multi Condition's

Hello Everyone,

I have applied IF formula with multi conditions but when comparing date, then it's not working. Could you please look in attached file. I have mention everything there.

I got stuck when comparing 0 with 3 conditions. Please provide if new formula other than if can be work also. Please help!



Thanks & Regards,
Deepak Sharma
 

Attachments

  • ABC.xlsm
    51.2 KB · Views: 6
Try,

K3, copied down :

=IF((G3=0)*(YEAR(I3)=2017),"Too Low",IF((G3=0)*(YEAR(I3)=2018),"Yet to be",IF(G3="","",LOOKUP(G3,{0;1;8;15},{"Too Low";"Low";"Healthy";"High"}))))

p.s. my formula nearly same as Naresh's.

Regards
Bosco
 
Last edited:
......
=IF((G3=0)*(YEAR(I3)=2017),"Too Low",IF((G3=0)*(YEAR(I3)=2018),"Yet to be",IF(G3="","",LOOKUP(G3,{0;1;8;15},{"Too Low";"Low";"Healthy";"High"}))))
Bosco

I think the 1st part of IF function included inside LOOKUP function and can be saved, become >>

=IF(G3="","",IF((G3=0)*(YEAR(I3)=2018),"Yet to be",LOOKUP(G3,{0;1;8;15},{"Too Low";"Low";"Healthy";"High"})))

Regards
Bosco
 
Last edited:
So Quick & Awesome Replies Guys! Every formula is working !!

Bosco you have shorten it amazingly !!!!

Thanks Naresh, Bosco & Nightlytic.....Thank you so much!

Regards,
Deepak Sharma
 
Back
Top