Get instant live Excel expert help with IF AND Functions

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

In cell K12, use an IF and an OR function that will return “Y” if the Note column equals either “Damage” or “Repair”; otherwise, the function will return “N”. Copy the formula through row 130.
Solved by O. C. in 21 mins
I need help on automated updating of cell C2, currently im using IF ELSE statement which is limited at 7 nested if functions. Total Quantity Sold is updated from another file. I have several item from several shipment each with varying cost price. what the nested if else statement is doing is that, cost price start with shipment one, once quantity sold has exceeded quantity from shipment 1, it will update to the cost price of shipment 2. Once quantity sold has exceeded quantity purchase from shipment 1 and 2, it will take the cost price of shipment 3. Please assit on how to do away on the nested If else statement. thanks!
Solved by E. U. in 29 mins
If column b in tab Top Sheet matches column B in Recibido sheet, return "Recibido" in Top Sheet Column W else If column b in tab Top Sheet matches column B in Evaluado sheet, return "Evaluado" in Top Sheet Column W else If column b in tab Top Sheet matches column B in Aprobado sheet, return "Aprobado" in Top Sheet Column W else If column b in tab Top Sheet matches column B in Entregado sheet, return "Entregado" in Top Sheet Column W else Return "" //blank
Solved by T. B. in 13 mins
I need formula to express: IF (23 > 0 AND 26 > (24+ 23), 26-23-24) ELSE IF (23 <= 0 AND 26 > 24, 26 - 24) ELSE 0
Solved by M. H. in 18 mins
I need a formula that will look at the value in column R and if the value is "F1" <-*{F# would be actual value entered and is not referencing a cell} return the value of "20" to the same row column T {so that 20 can then be multiplied by a number value in column S using a separate and different formula}.ELSE if the value in column R is "F2" *{same reference as above} return the value of "30" to the same row column T {so that 30 can then be multiplied by a number value in column S using a separate and diffenrent formula}.
Solved by C. C. in 17 mins