# 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

I am using the AND function on the condicional formatting option and it gives me a command error. Formula is: =AND(A2>1,A2<100)
Solved by K. U. in 24 mins
can you teach me the steps to create a nested if function, and to nest an AND function inside of an IF function?
Solved by A. Q. in 12 mins
In cell P14, use an IF function and an AND function that will return 5 points if the Freshman Satisfaction (Fresh_Satis) AND Graduation Rate (Grad_Rate) are greater than 50%. If both conditions are not met, the college will receive only 1 point.
Solved by E. J. in 29 mins
I need to have this tracker apply an hourly rate to the equipment and operator type in the data tab
Solved by B. F. in 13 mins
How can I tell how many apples and oranges I sold last week?
Solved by M. H. in 22 mins
The identical value in the data is seemingly arbitrarily split into two columns in the pivot tables. On the attached workbook, the red worksheets contain the data; the other colours are the pivot tables. As an example, I checked each cell containing the value "All" using the "=ISNUMBER" function. All returns were "FALSE", which if I understand correctly means that the value is text. This is as it should be. The purple worksheet "Lecturer totals T1" contains two columns for "All", "Lecturer totals 01-17" contains two columns each for "BaL" and "HLS" "Lecturer totals T2 & 3" contains double columns for all these three values. The same is true for the equivalent green "Faculty totals" and orange "Student totals" worksheets. How can I ensure that the pivot tables only contain one column for each of these values?
Solved by E. D. in 13 mins
I have a report template and I want to be able to link a raw data page to it so that whenever anyone inputs raw data it automatically is populated into the template and organized by project title. I've used If, Search, V lookup, and Isnumber functions and have not been able to get the desired effect. Ex. Page 1 Template with Column Labels: Purple, Blue, Red, Yellow Page 2 Raw Data List: Purple Shoes, Purple Hat, Blue Socks, Red Scarf, Blue Tie etc Page 3 Automatically populates with all the Purples under the Purple column, all the Blues under the Blue column etc. Formula Examples: =IF(ISNUMBER(SEARCH('Goal SLAs'!\$E\$8,'Raw Data'!\$C:\$C)),'Raw Data'!C2:C2,IF(ISNUMBER(SEARCH('Goal SLAs'!E5,'Raw Data'!C:C)),'Raw Data'!C3,"error")) =IF(ISNUMBER(SEARCH('Goal SLAs'!E18,'Raw Data'!C:C)),'Raw Data'!C12,"") =VLOOKUP('Goal SLAs'!E8,'Raw Data'!A1:H10,2,TRUE)
Solved by A. C. in 27 mins
In the Eligible for Bonus column, enter a formula with IF and OR functions to display the text no if the employee's pay grade is D or the employee's job status is a part time (PT). Leave the cell blank if the employee is eligible for a bonus
Solved by D. W. in 30 mins