If And Formula

**Leonardo1234** · 03-09-2023, 08:40 AM

Hi,
I am Looking for a formula that will help me in doing the below things

If (E2>B2 And K2 >3,"BCC",IF( E2<B2 And K2>3,"SCC",""))

Thnx for the Help

**KOKOSEK** · 03-09-2023, 08:42 AM

AND (condition1,condition2, conditionX), so:

Formula:

Please Login or Register  to view this content.

however, according to the fact that condition about K2 is the same in both ANDs:

Formula:

Please Login or Register  to view this content.

or even, if there is no possibility that E2 is equal B2:

Formula:

Please Login or Register  to view this content.

**Leonardo1234** · 03-09-2023, 08:54 AM

Problem Solved
Thnx KOKOSEK for a Great Help

**Leonardo1234** · 03-09-2023, 09:13 AM

Is the below formula perfect according to u KOKOSEK
bcoz it is 3 %
=IF(AND(E2>B2,K2>3%),"BCC",IF(AND(E2<B2,K2>3%),"SCC",""))

**leigh3980** · 03-09-2023, 09:21 AM

Hi Leonardo,
It would be great to have a representative excel sheet to demonstrate what you need. Is K2 presenting % difference between E2 and B2?

thanks

Leigh

**Leonardo1234** · 03-09-2023, 09:22 AM

Yes Sir K2 presenting % difference between E2 and B2

**leigh3980** · 03-09-2023, 09:35 AM

Hi Leonardo,
I am assuming you need a formula to work out K2 as well. Please see attached example worksheet, I have included the formulas you need

I have kept the formulas simple so you have a good chance of updating them if you need to change your worksheet columns etc.

Again a reputation star is always a good way to say thnx

Leigh