ifs and

I need help with creating 2 formulas for the sheet pictured (I typed the info that I want momentarily, however, I need a formula to generate it in the future). First, I need a formula that will look at G26 & K26 and place text in U30 based on the value in G26 & K26. I know what I want to do...

I am trying to make one formula that can incorporate many ifs, ands, and ors. Here are my individual statements: If D13 or H13 is “Lead” or “Lead-lined” then K13 should be “Lead” If D13 and H13 contain “Non-Lead” then K13 should be “Non-Lead” If D13 and H13 contain “Unknown” then K13 should...

I am working on making some updates to a training tracker and am having trouble pulling out just the numbers to make adding a score to responses automatic. The possible answers we can get back range from 1-5 and have a letter with it. There can be multiple answers provided for each column. When...

I am using a formula =IF(AND(S4="NO",W4="YES"),V4,Q4) in this same cell I want to add another condition that IF(AND(S4="NO",V4="NO"),M4,0) how to add these two ??

Hi. I have two sheets that I have to get data from each other. I have multiple criteria and I want to downsize my formula length. If any alternative way you know please enlighten me. In the first sheet I have 2722 rows. My criteria are performance score of employees, their score of grades and...

I am really struggling with this and while its just the first part it technically controls everything else. Say I have 18 (I've only shown 12) rows and the data represented in these rows are dependant on a table (for want of a better word) The table contains 4 pieces of information which will...

hey there, im trying to change a co-workers if statements into an array if possible im trying to validate that If Colum AA is 1 or greater then to check if Colum AQ is between 7.3 and 8.3 and if its anything else to check Colum y and if there is a date then colum AQ should be zero, if there isnt...

So after many hours and lots of assistance I am nearly there. What I would like now is the following, this is my current formula: =SUMIFS(Group1!$N$3:$N,Group1!$D$3:$D,"<="&$B$14) I would like to add to this formula is 3 more criteria. That formula is in H14 and I would like to add H13...

I need to update the below formula to include this piece: IF(AND(Rate_Card_Selection="Company B",C19="Remote Access Points"),0,150)) What is the correct way to nest the IF AND function into the below? =@IFS(C19="Company A (London)",325,Inputs!C19="Remote Access...