iffunctions

Hi I have a meeting I would like to ensure has all the required specialties in attendance to ensure the meeting is quorate to make decisions. So for example the meeting must have 2 surgeons, 1 nurse & 1 radiologist in attendance to be quorate (able to function). To check if each specialty is...

Hello, I'm new to Excel and I've been going around in circles trying to figure out if I can even do what I need to via nested IF functions. Here is a screenshot of my what I have so far: The first IF function I need to populate in Q28 is IF(D28="N", "N/A", ""). I want Q28 to remain blank if...

Hi All, I'm trying to create a formula that will allow me to search 3 different strings within a field that contains a long piece of text and then give me 3 separate and different strings depending on what is found. As per the table below I will be searching for either Class1, Class3, or Class...

I want to refer to the last date of the data set and make the cell value move UP until cell value is equal to text or in this case "BRL" If it is text, I want excel to run the formula in BLUE, otherwise I want excel to move up the column until it finds a text. =IF(ISTEXT(A9)...

Hi, I'm trying to compare the standard deviations 2 different data sets A & B over a period of time. The sets of data do not begin at the same time however, so I'm looking for a formula that will exclude data from the standard deviation calculation of B where there is a blank value for the data...

I'm working on a better way to do attendance at our company, I'll try to explain this as best as I can, I'm hoping someone can give me some direction! I have a master list of all of our current employees. (Fig.A) At the end of the week I run a report that lists every shift that was worked...

I am sure this has been asked before, but I need all the assistance I can get with this...We have implemented a new tracking system that requires us to calculate the total numbers of days between two dates if one cell contains a date. However, one of the dates you must add one day to it then...

Hello I am trying to use the if function but I am having so trouble coming up with the correct answers. Here is a little background: A company has the following compensation for its sales department: A 5% commission on the actual selling price for cars sold at 98% or more of the asking...