• 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.

Please help me for excel formula to our Dashboard.

sampath

Member
Hello,

I have a tracking sheet for our production. Following requirement mentioned for this needed excel.

If A1<="10" then B1 is "C4"
If A1<="50" and >"10" then B1 is "C3"
If A1<="65" and >"50" then B1 is "C2"
If A1<="120" and >"65" then B1 is "C1"

please suggest the formula for above mentioned condition.

Regards,
Sampath.S
 
Hi Sampath,

Here you go...

=IF(A1<=10,C4,IF(AND(A1<=50,A1>10),C3,IF(AND(A1<=65,A1>50),C2,IF(AND(A1<=120,A1>65),C1,""))))

Hope it helps!!

Thanks,
Ramesh Kumar.P
 
Hi,

paste this formula in B2

=IF(A1<=10,C4,IF(AND(A1>10,A1<=50),C3,IF(AND(A1>50,A1<=60),C2,IF(AND(A1>65,A1<=120),C1,"Not matching"))))

File attached.

Regards
Ajaar
 

Attachments

  • If condition.xlsx
    9.9 KB · Views: 1
Last edited:
Back
Top