or formula

Hi all, I am currently trying out this formula: Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!") Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...

Hi there, I am trying to return one value from a list of values where this list will be growing in the future. So the spreadsheet looks like something as below Where column D will grow in the future. The issue I found so far is that the SEARCH formula only looks for one row at a time. Using...

Hi Forum, Sorry to post so much today. I posted a question earlier today and a user helped me find a solution to scenario 1 i outlined below. However after further analysis on my data i see that i have missed a scenario which i didn't include in my initial thread, consequently the formula...

Good morning! I need help with a DATEDIF formula. This is my original formula: =ROUND(IF(YEAR(AC93)=2018 & MONTH(AC93)=8,"0",DATEDIF(AC93,"8/1/2018","m")/12),0) It works perfectly when the date in cell AC93 is 8/1/2018, which is what most of the 1,000+ employees I'm calculating years of...

Hi there, I am trying to create a formula that if the criteria in column D = Z and either the value (OR) in E2 or F2 is blank to return the value "Check" =IF(AND(D2="Z",OR(ISBLANK(E2)="True",ISBLANK(F2)="True")),"Check","Fine") My formula does not evaluate correctly above - any ideas?

I need to extract a word between 2 different strings. The first strings starts in any of the following words- LTD, LP, FD or LTD. And it ends before the word "TWO". I'm thinking of using mid function but it can only be used for one argument. Example: I need to extract the following : ASWU...

I'm trying to write a nested IF formula that the first argument looks at a particular cell and is supposed to find any value other than Yes or Discontinued. I've put in my logical test =if(or(A1<>"Yes",A1<>"Discontinued"),True Statement,Further IF Formulas). On the cells that contain Yes or...

Hello, I have a spreadsheet that is comparing quarterly figures in two separate columns. The IF Formula I have allows me to show increases and decreases with arrows formatting the cell with Wingdings3, however what the formula does not allow is to show no change as you can see in row two, both...

I have Several Countifs and want to make it into one saying if this area was assigned by one of these people count the job, I have tried many different ways and can not seem to make it work. unless I have it search for each assigning Person one by one. Is there a way to make this Formula much...