How can I write formulas with conditions and spill in Excel (IF plus FILTER)?

56 Views Asked by At

I’m trying to use the FILTER formula in Excel to return all values from a column that meet three possible conditions:

If column D equals "CDI" or equals "SELIC", return the value from column K;
Otherwise, return 0

But I need this formula to be dynamic in the number of rows, in the style of spill functions. I’m not able to create an IF formula that meets my needs.

The filter function I’m applying is this:

=FILTER(D:D;(D:D="CDI")+(D:D="SELIC"))

Is it possible to combine it with the IF function?

Thanks in advance!

0

There are 0 best solutions below