Please help me for excel formula to our Dashboard.

[sampath]

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

 

[Ramesh]

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

 

[ajaar]

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

 

[sampath]

Thanks for your support. This is my requirement what I expected.

Thanks once again!