Get instant live Excel expert help with IF Functions

Now company is changing requirements and next scheduled training should be scheduled based on a three year cycle from hire date. Eg, Employee was hired in May 2013. His schedule will be May 2016, May 2019, May 2022. If he is not able to attend May 2016 training and will attend sept 2016 training he/she will still have to attend May 2019 training. Task: How to calculate who will be due /will not be due for training in 2018, based on the training requirements to take training every 36 months form last hire date.

Looking to get a report that identifies each person who's date has expired for each of the yellow highlighted columns and transfers that information to the applicable report page. Expiry can vary but each if formatted so that the date turns red on expiry.

Is there a formula that can solve: (This is scoring from an audit) If a score of 0 = 100% and a score of 14.99 = 50%, what would be the percent if the score was 53.32 and what would be the percent if the score was 1.49? Is there enough information to create a formula for this?

Data is seemingly arbitrarily split into two columns in the pivot table, and I can't figure out why. In the purple worksheet "Lecturer totals T1" you'll see two columns for "All". On "Lecturer totals 01-17" you'll see "BaL" and "HLS" twice. On "Lecturer totals T2 & 3" there are two columns for each of "All", "BaL" and "HLS". On the green "Faculty totals T1" worksheet, "All" has two entries. There are similar cases in the other worksheets. I've tried applying the "=ISNUMBER" function to each of the cells containing "All" in the data (the red worksheets). These return a FALSE reading, which (if I understand correctly) means that they're text, which is what they should be. Depending on when you answer, I might not be able to continue the conversation before tomorrow around 0900.

I have two columns with student ID numbers and I need to know if there are any duplicates between the two while keeping the names with the ID numbers.

i want formula like this if(a8&b7) = b8 (want to display what is there in b8 cell)

What I need is for his "vest" to show "RFI" as long as his "LPU"(D6), SRU-42(F6), and CSEL(H6) are not expired. When they do expire, I need for the corresponding cell(D6 for example) to turn red, and his vest(B6) to say "NRFI" and turn red.(I believe I have figured this portion out as you will see if the formula bar). But also, if were to type in "MFR" or "AIMD" into "D6,F6, or H6" i still need his vest(B6) to say "NRFI" and still turn red (This is what I am unable to figure out). How do I incorporate this second part into the existing formula?

So i have this excel file full of data relating to a survey taken from roughly 1700 households. Each household is number (1,2,3,4...) and has corresponding columns relating to it such as no. of people in the household, whether children go to school etc. My problem is, is that i need to take a random sample of 1400 households and still carry over the corresponding data from the neighbouring columns, but whenever i use the sample data toolpack, it just takes 1400 random number across all columns. If you could please help me, it would be greatly appreciated. The data file is attached below.

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?

howdy! I am attempting to collate data from multiple cells in the "related_asset_id" colume into the same cell in "new_related_id" column , if and only if the cells all have the same "title"