mardi 5 janvier 2016

Excel Conditional Formatting IF formula

I am trying to find a formula for the following example scenario:

In column A will be a 'Yes' or 'No' value. In column B will be a numerical value.

If the cell in column A is 'Yes' I would like the cell in column C to copy the value from the cell in column B.

Is this possible, if so what is the formula for this? Thanks.

Aucun commentaire:

Enregistrer un commentaire