logical function

Hello experienced and talented Excel people. Example. I am working for a company and I have segments, brands and variants. Example: Segment:Coffee, tea, chocolate Brands: coffee--> Nescafe, ground coffee Tea --> green tea, freshly cut leaf Chocolate ---> white, dark, 100 cocoa Variants...

Hello. I have a list of people who need to select training dates from a list available. I have created a Data Validation drop down menu for the people based off a list of classes available. I have also created FILTER formulas to sort the attendees into attendance lists. My only issue left...

Hi, I currently have the formula below looking a set of data comprised of people and percentages. The formula currently looks at if a person is in the bottom 20% and are below the target (0.815). From this it produces either a 3 if they are both below target and in the bottom 20% or a 0 if...

Hi, I have various columns including column F, J (both have dates values or no value/no dates) and U (which has a text value) I want to say that if at least one of the columns meet my criteria then, it shows the row as Active / Inactive. However, the function below only gives me inactive even...

I may be wrong, but I'm thinking I need to write an if function to accomplish my goal but can't seem to figure it out on my own. I have 13 columns and 26 rows. Rows list names of staff and columns list the months of the year. For each staff name listed on each row, when "yes" is entered into...

Hi Friends, I needed a formula to add on to a column , if the product shipped Complete on the same month it should say "On time" if not "Late" if nothing has shipped and still has not passed October then it should be saying "0" <tbody> October ORDER OCT SHIPPED LATE /ON TIME 100 100 On...

Dear reader, I made a spreadsheet with some measurement results. All measurements have an maximum acceptable value or a minimum acceptable value, some have both (so a range). I added conditional formatting to get red coloured values of they are outside this range. The problem arises for those...

I'm trying to build formulas to calculate the amount of window casing required for separate conditions. Window casing can be applied to a window as a picture frame ie, casing goes on all 4 sides of the window. In another condition, a windowsill is installed, and the casing is only applied to 3...

Hi there, I am new to this forum (1st Post) and also new to excel. I am currently doing my bookkeeping course and i am stuck on a question and need some help. The exercise asks me to create a multiple nested IF statements (with the average function nested in the IF statement) in column F to...

Hi All, i need help to make an logic statement for my data. i have this data: A B 1# T/T G/G 2# C/C A/A 4# T/T G/G 5# T/C A/G 6# T/C A/A 7# T/C A/A 8# C/C A/G 9# T/T G/A 10# T/T...

Hello: I have an issue with Conditional Formatting in Excel 2010 (actually 2 issues but I believe they are related): 1) I want to change the format of a cell based on an AND logical function with 3 arguments: ex: =AND(A<>"",B="",C=""). However, Excel ignores the 3rd argument and only applies...

Please help What I am looking for is that I have a sheet that has grades. I have it in 4 sections for quarterly. I am trying to do is in B1 is reference 4 different cells and determine 4 different results according to the data is these cells and copy from another 4 cells depending on the...