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...
All that is required is a formula. One such possibility is
= IFS(
AND(condition1="yes", condition2="yes"), 5000,
OR( condition1="yes", condition2="yes"), 3000,
TRUE, ""
)