jeudi 4 juin 2020

Using If Statements to then Replace a Cell

I have a single excel worksheet. I want to replace text in column F IF both Column C has a particular text ("apple" and Column F has a particular number ("56"). I want the replacement value for the Cell in Column F to be "1".

To summarize, if c3=apple and f3=56, I want f3 to be changed to 1.

But if c3 is anything but apple or f3 anything but 56, I do not want anything changed.

Aucun commentaire:

Enregistrer un commentaire