Forum Discussion
Conditional filling of a cell
This is not conditional formatting. I would like to ask for advice: I have two cells and I need to insert a function into another cell that automatically fills in predefined text depending on whet...
Another option is simply to count the "yes"s
= LET(
yesCount, COUNTIFS(conditions, "yes"),
CHOOSE(1 + yesCount, "", 3000, 5000)
)The formula is expressed using Excel 365 syntax.