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 whether both cells meet a certain condition and another text depending on whether only one of the cells meets a certain condition.
An example: If both cells contain YES, then the amount 5,000 will appear in the third cell, however, if only one cell contains YES and one contains NO, then only 3,000 will appear in the third cell.
Thank you very much for advice!
Nikol
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 whether both cells meet a certain condition and another text depending on whether only one of the cells meets a certain condition.An example: If both cells contain YES, then the amount 5,000 will appear in the third cell, however, if only one cell contains YES and one contains NO, then only 3,000 will appear in the third cell.Thank you very much for advice!Nikol Read More