Not able to apply multiple logical conditions using if, AND, OR functions.

Hi All,

I have to decide if the final answer will be yes or no based on a combination of 4-5 cell values from a single row.

I have attached the details in the excel sheet.

Regards
Jerry

Originally Posted by FDibbins

1st, you have a double space in "copy Center" - remove 1 space

next, you didnt really say if you wanted the other cells to have formulas, so assumed you did...

E6=IF(K6="No",2960,0) (you did not specify what to do if "Yes")
G6=IF(H6=48,"Yes","No")
H6=IF(B6="Copy Center",48,24)

L6=IF(AND(B6="copy center",K6="No"),2960,0)

Thanks for the promp reply. The conditions mentioned in the excel sheet should basically be applied on single cell i.e. L6. I am not able to make it work using If condition,AND operator. Inshort to decided the L6 value if yes or no, it should check all the three conditions mentioned below.

Originally Posted by bebo021999

How about:
=IF(H6=48,IF(B6="copy center","No",IF(G6="Yes","No","Yes")),IF(AND(K6="No",E6=2960),"No","Yes"))

It didn't work. I have attached the sheet again & have simplified the requirment. Let me know if it helps.