ifs statement

I have a dataset with 500+ athletes, each with information on age category, best distance, season in which PR was achieved, and the absolute time of the PR. On another tab ("SBT") I have the overall season best time per age category on 6 distance over 5 seasons (total of 150 season best times)...

Hi, I'm looking for a formula to compare differences between two columns (A & B), so that it returns a comment - "No change" or "Difference" - in column C. But I would like the formula to return a blank (or a statement to say "Fine") if the value in column A is also blank. Essentially, I need...

I'm trying to design a spread sheet I will also uses as a display. I am wanting to add the row, but if the cell under if says "Half" I want it to divide the number above by 2 then add it. So in my picture B4 is 1 but since B5 says Half I want it to add as .5 will C4 still adds as 2 in U4. So U4...

Hi, This is my previous thread which got resolved: "I'm trying to use the Textjoin function in VBA. I know how to do it for the first row, but I'm having issues when I want it to apply for the whole column. For example, I want it to start at AH2 and the formula on the cell should be...

Hi, I need help with an if statements as I have tried a couple of things now and I just keep getting errors. I have a table (see image) and its in regards to an acceptance criteria. I need the formula outcome to state accept or reject. I have also uploaded a screenshot of the acceptance...

I am trying to get an if statement to work in where 1. if cell = text refer to another cell 2. if cell = text refer to another cell 3. If cell does not have either text then index match... The first two are working fine. The third is giving me a value error. If anyone can help! =IFS(I241="b /...

It seems that the last part of this statement that uses the SEARCH formula is not working (highlighted in red). If cell C2 contains "1%", it will return the correct answer, but if it contains "2% or "4%", then it will return #value . Basically, the formula recognizes the first SEARCH, but not...

I am hoping to find assistance with a formula that will help me identify which requisitions have been fully or partially awarded. Each requisition may have multiple lines and none, some, or all of the lines might be awarded. In the example below Requisition 111111 has three line items, but...

Hello, I'm relatively new to macros, and need to run one that runs a loop that sums anything in 2017 in each worksheet. There are about 20 worksheets that all set up like this; Payment date Beginning Balance Monthly Payment Interest...

Hello, I'm trying to forecast values along down a table. I have already used Forecast (Linear) formula without a problem, but now I need several conditions to be met. This is what I have so far: {FORECAST.LINEAR([@Date];AND(IF([Date]>=([@[Date]]-5); [Score];"");IF([Date]<[@[Date]]...

Can I write an Ifs statement that contains several inequalities? Below are the criteria: If Cell >=15% then value= 1 If cell is between 6%-14% then value= 2 If cell is between -5% and 5% then value = 3 If cell is between -6% and -15% then value = 2 If cell is less than -15% then value = 1