I have the below formula which works fine and returns the expected results. =ARRAYFORMULA(iferror(if(row(I:I)=1,"CE Credit", if(A:A="","", VLOOKUP(I:I&" "&U:U,importrange("abc123","Course Catalog Database Export!E:N"),3,0))),"!!!")) I need to add a condition. If the vlookup results is greater than 0, I want it to return Yes, if not No. =ARRAYFORMULA(iferror(if(row(I:I)=1,"CE Certificate Needed", if(A:A="","", if(VLOOKUP(I:I&" "&U:U,importrange("abc123","Course Catalog Database Export!E:N"),3,0)>0,"Yes","No")),"!!!"))) However the… Read More Google Sheets Array If Condition

I have two columns with the range O6:P that evaluate the row of data in J and display Pass or Fail. The results in O and in P are not always the same. One can display Passing and the other will have failed. The code I have here works for the most part. Except that… Read More Selecting a range based on values of two other columns

Summary I have built a flask application thats taken several inputs from the user and the inputs need to be verified to certain criteria. If the inputs are not verified correctly, a flash message will show depicted what is incorrect of the input. The home page has 4 nested if statements which displays certain messages… Read More Alternative to Nested if statements Flask

I have the following data – number, value, date. I need to find the right percentage based on the following conditions: 0-10 – 40% 11-20 – 50% 21-40 – 60% and a few branches for 70%: If date>=’2022-01-01′ then, for 70%, number should be >41 and value>10, if date<‘2022-01-01’ then, for 70%, number >41 or… Read More Google spreadsheet formula with several conditions

Currently I’m involved in data manipulation task in order to create a data table ready for further analysis. Suppose in a small data frame two date columns are around: Treaty_Date.x Treaty_Date.y 1 2020-12-31 <NA> 2 <NA> 2019-05-22 3 2020-10-13 2019-09-01 The first one is "Treaty_Date.x", the second – "Treaty_Date.y". NA’s are also available. Implementing a… Read More "ifelse" function eturns numbers instead of dates

I’m currently having a problem with my code specifically the If-else part. If my year-level is 1, the if-else is satisfied but if the year-level I’ll input is 2, 3 or 4, the if-else for these are satisfied HOWEVER, it always displays the if-else for yrep1 (It always prints "Year-level Representative: Lady Carmel") except if… Read More One If-Else statement is always read