IF/THEN formula with multiple conditions?
Our take
What I need is a formula that I can apply to 6 different conditions. So I need it to be if Test condition = TC1 and exposure condition = EC1 then it goes to a specific part of the spreadsheet, etc. (determined by those preset conditions, as the Test condition determines where there is data as otherwise it is blank) and then count the number of “yes“. I want this to be a formula I can include all 6 potential combinations of test condition and exposure condition so I can have it do this automatically for each line of data. I tried a COUNTIFS formula but that just returned a #VALUE! error. I was thinking I could just spaghetti code the formula with a combination of COUNTIFS, COUNT, and IF but I was wondering if there was a more elegant solution. Sorry if this is not well explained I am happy to clarify anything that does not make sense.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need more than 3 outputsI’m looking for the cleanest way to add this. Having it feed from another sheet is open to consideration as well. Basically what I’m looking for is an IF OR formula for 3 conditions and 3 outcomes. If cell A1 is A the B1 will display as Yes If Cell A1 is B then B1 will display as No If cell A1 is C then B2 will display as maybe Any suggestions? submitted by /u/Amazing_Complaint_13 [link] [comments]
- IF/OR Formula with multiple criteria not working as desired (365 for enterprise - beginner)Hey all, I'm trying to make an IF/OR that will generate a "YES" even if only one of the listed criteria is met. Originally I was trying: =IF(OR($B2>6,$C2<80,$D2<3775, $E2="Y"),"NO","YES") Basically, if absences are greater than 6, Grade is lower than 80, STAAR score is less than 3775, OR Discipline = Y, then the output should be NO, the student is not eligible to exempt. However what I'm seeing is that nothing is happening unless I enter the STAAR score. Even at zero absences, the data does not change to YES. SO, I attempted a modified, more specific formula: =IF(OR($B2>6,$C2<80, $C2>0,$D2<3775, $D2>1649, $E2="Y"),"NO","YES") Even if I enter data that should result in a YES in the "Eligible?" column, it remains unchanged until I enter the STAAR score. Other note, I do have conditional formatting on columns B, C, D, and E, but only to change the cell color if certain data are present. For example C2>6 will turn red, C<6, C>2 will turn yellow, and C<3 will turn green. Please advise! Any help is appreciated. submitted by /u/The-Sweetest-Pea [link] [comments]
- Countifs with mutiple conditionshello! if anyone can help will much appreciated been stuck for one week for this. this my formula. IFNA(IFS(COUNTIF(G2,"\*DONE\*"),"logged in the system", SUM(COUNTIFS(K2,{"\*Depreciated\*","\*Depreciated\*"})),"For disposal/salvaged parts", sum(countifs(c2,{"\*false\*","\*false\*"})),"Get info in the engr. dept"),"For checking") I know there is mistake in my formula. i just can't correct it yet. I can't trigger some of the returned conditions. Edit: should be column in the picture should be results. Thank you for any being kind helping me. submitted by /u/Ok_Vacation_7897 [link] [comments]