 # 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

Disappointing that you baited me to wait, before eventually saying that chat support is only for formulas and functions. I hope to never come across this site again.
Solved by I. J. in 17 mins
I need help using the RAND and excel AND functions and applying specific conditions
Solved by E. J. in 15 mins
Pivot Table formats and functions are lost after my file is saved. Even older versions of the file that had opened fine before will not now. What gives?
Solved by V. D. in 22 mins
Assume that the City Council in Prescott, AZ is considering implementing price ceilings on rental units based on the number of bedrooms in the unit. The demand function for rental units (on a single bedroom equivalent basis) is given by QD = 120 – 4P and the supply function is given by QS = 2P, where P is price and Q is quantity. The Council is giving consideration to imposing a ceiling price on rental units of Pmax = 16.
Solved by G. L. in 12 mins
Hi, I am looking for IF AND function help. I need to use multiple IF nd conditions in single formula.. eg: condition 1: If cell A2 = 1630, cell B2>=15,"YES","NO".. condition 2 : If cell A2 = 1627, cell B2>=8,"YES","NO".
Solved by S. Q. in 30 mins
Hi! I am trying to create a quartile if function based on any one of several conditions being bet and then a quartile and if function with two conditions being met.
Solved by C. Y. in 21 mins
Each client can choose 4 consultants, each consultant can choose 2 clients. The upper table shows which consultants each client choose. The lower table shows which clients each consultant choose. I want to use vlookup and functions to get result in Column G, the result of which consultant are not matched for each client. For example, for A client, A chose 1,2,3,4, but the lower table shows, consultant 1 chose A, so 1 is matched to A, however, A chose 2, but 2 didn't pick A, so 2 appeared in Result (not chosen). After this is solved, I want to compute how many times consultant chosen, how many times they are repeats in the lower table.
Solved by A. A. in 12 mins
What is the proper way to nest AND functions within an IFS function? I am trying to test a value between a range of numbers. IF Value is > 0 and <= 15 I want it to plug in a value from X6 for instance. IF the Value is >15 and <=20 I want X7 instead. IF the Value is >20 and <= 30 I want X8's value and so on. I have 51 IFS in this nest because I have 51 different X# values.
Solved by T. U. in 23 mins
=IF(AVERAGE(C6+E6+G6)>=5000,TRUE,FALSE) I am using AND function and it is not giving me the correct answer
Solved by G. J. in 12 mins
But if the value is false, nest a second nested if function and excel in which the logical AND test determines if the Discontinue in K19 is equal to "N" and the Current Inventory is less than or equal to the rush reorder point in J19. If the value is true, "Rush" should be returned. If the value is false, then nest a third IF and AND function in which the logical test determines if Discontinue (K19) is equal to "N" and Current Inventory (H19) is less than the Reorder Point (I19). If the value is true, return "Reorder". If the value is false, return "Ok".
Solved by D. B. in 22 mins