and and or function

I have 6 dropdowns with the same 30+ options to choose from in each. 10 of those options have similar attributes and I want to advise the user if they pick 4 out of 6 of these when filling in the 6 dropdowns. I have a cell off to the side of these options that will display this message. I got...

I need to answer the question " How many who were referred (Yes) had at least one test (x)" on a tab separate from the data tab. I'm working with a data tab (1000+ lines) and a reporting tab. Using =IF(AND(A2="yes",B2:E2<>""),"Referred to Test","") on the data tab will tell me which lines meet...

Hello, I'm not sure how to ask the question to my problem, hopefully, my question makes sense: I am using Excel 2016. In Worksheet A, cell A1 = $1,000, cell A2 = $1,000, cell A3 = $1,000. In Worksheet B, cell A1 needs to equal if cell B1 = X then worksheetA1 and/or C1 = X then worksheetA2...

Hello - Thanks for taking a look at this - I have been trying to get this right, and I keep on getting an error. I know it must be in the parenthesis syntax (at a minimum), but I am missing something...any help will be very much appreciated! This formula works fine...

This is what I have =IF(AND(OR((Descriptions!B3="x",Descriptions!C3="x",Descriptions!D3="x"),(Descriptions!B3="",Descriptions!C3="",Descriptions!A3=""),( Descriptions!B3="",Descriptions!A3="", Descriptions!D3="x"),( Descriptions!C3="",Descriptions!A3=""...

Hi all, I have the following fields of data: A2 'values': (shows the value 'low', 'mid' or 'high) B2 ' ratings': (shows a value rating of between 1-5) I need a formula to populate the %'s in the table below, based on the rating and value. I.e. If Rating is 1 and value is 'low' show 0, if...

Hello all, I've got a question about the if, and, and or function. This function has to look in 2 cells for a value and then give a specific result. I will explain this by a example. Part 1 In cell A1 the user has to choose from a listbox for a value A, B, C or D. In cell A2 the user can...