Hi Team,
I am trying to get a IF formula with a Filter function to work.
I have a table that I am referencing and I am trying to get the If formula to show a Yes/No result ONLY if the condition is met at least once.
The formula Is looking for a number that is greater than 2, if the other 2 filter parameters are met.
Sometimes there are multiple filter matches but all of them would = NO, and in which case I just want a single NO to show in the cell not one for each filter match (then all subsequent formulas will calculate as normal in the sheet)
On the chance though that there is even just 1 entry that meets the parameters then I need the result to display YES (so all subsequent formulas stop/other errors show etc)
Therefore, I don't need the result for every filter match, just an overall.
I can't use the text join function because this result feeds into other formulas which operates off the result.
Is there any better way to do this or to fix my below formula??
Hope that makes sense, thank you so much!
=IF(FILTER(Car1_TMR[Distance],(Car1_TMR[To]="Total Distance")*(Car1_TMR[Business Zone Trip]="Journey started and ended in a Business Zone"))>2,"YES","NO")
I am trying to get a IF formula with a Filter function to work.
I have a table that I am referencing and I am trying to get the If formula to show a Yes/No result ONLY if the condition is met at least once.
The formula Is looking for a number that is greater than 2, if the other 2 filter parameters are met.
Sometimes there are multiple filter matches but all of them would = NO, and in which case I just want a single NO to show in the cell not one for each filter match (then all subsequent formulas will calculate as normal in the sheet)
On the chance though that there is even just 1 entry that meets the parameters then I need the result to display YES (so all subsequent formulas stop/other errors show etc)
Therefore, I don't need the result for every filter match, just an overall.
I can't use the text join function because this result feeds into other formulas which operates off the result.
Is there any better way to do this or to fix my below formula??
Hope that makes sense, thank you so much!
=IF(FILTER(Car1_TMR[Distance],(Car1_TMR[To]="Total Distance")*(Car1_TMR[Business Zone Trip]="Journey started and ended in a Business Zone"))>2,"YES","NO")