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

How do I get the following into formula? If and column A,B & C = 100% or higher column E = column D (sum of A,B&C) if column D =100% or higher otherwise is 0.00
Solved by I. W. in 24 mins
I'm using an IF AND FORMULA in column O based on certain criteria. I need to add additional criteria (if have have >0% royalty) in column J to the nested IF AND array formula, but I'm receiving the error message of too many arguments. This is my current formula: =IF(AND(M8>=$L$2,M8<$M$2),N8*$N$2,IF(AND(M8>=$M$3),N8*$N$3,IF(AND(M8<$M$1),N8*$N$1))) This is what I tried and got the error message: =IF(AND(J8>0,M8>=$L$2,M8<$M$2),N8*$N$2,0,IF(AND(J8>0,M8>=$M$3),N8*$N$3,0,IF(AND(M8<$M$1),N8*$N$1)))
Solved by I. H. in 15 mins
just need to make it easier to match data across columns... index? match, if ands?
Solved by C. A. in 17 mins
use of IF and ISBLANK formula to return different values
Solved by S. H. in 21 mins
So I am trying to create a Vacancy calendar that i can use to compile automatically and distribute the available vacancy week (max 3 employee in vacancy during the same week) Here my idea: B5,H5,O5 etc ... are the Week # the employee must choose. for B6,H6,O6 etc... i used =COUNTIF and take the data from a table where each employee made their choice On the table, the choice 1 is the one that shall be used if there are 3 or less employee that chose it, If there is more than 3 people who chose it, the second choice will instead be used and the 1 choice should be eliminated. I am struggling to find a solution on how the code can determine the priority of employee, cause the older employee will alway have priority over the newer employee.
Solved by E. J. in 30 mins
Hello, I am trying to create a pivot table that shows the overall trends of people's performance in an organization over the 5 years' worth of data we have accumulated. We are analyzing their performance via a survey that was sent to them. The issue is that sometime years people respond to surveys whereas others do not and that sometimes they answer a questions whereas other years they do not. I need to create a pivot sheet that shows if and how people are improving over the years for those who have answered the survey more than once. Can you help me with this? Thank you.
Solved by V. H. in 18 mins
Trying to add columns with an if and then. For example 0,0,1 - 1 0,0,0 - 0 1,1,1 - 1 etc.
Solved by Z. A. in 29 mins
Need help with if and then =IF(H4=1,IF(S4=".",0,IF(OR(S4<6,S4>28),0,IF(AND(S4>=6,S4<=28),1,0))),0)
Solved by I. J. in 28 mins
Need help with if and then formula 0,0,1 = 1 0,0,0 = 0 1,1,1 = 1 1,0,1 = 1
Solved by S. J. in 24 mins
I have a column on names (A) and a column of phone numbers (B). Now I want to sort these people by country but the only information I have on their country is the area code in front of the numbers. So I, therefore, have a list of area codes. I am wondering if I import the area code list onto excel, if and how I could create some sort of formula which would sort them for me. For example, something like "IF contains +33 " but I'd also need the names to stay with their corresponding number. Hope you can help, thanks
Solved by V. H. in 17 mins