Get instant live Excel expert help with IF AND Functions

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.

I need help using the RAND and excel AND functions and applying specific conditions

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?

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.

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".

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.

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.

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.

=IF(AVERAGE(C6+E6+G6)>=5000,TRUE,FALSE) I am using AND function and it is not giving me the correct answer

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".