mercredi 23 novembre 2016

Excel Formula with if, then

I need to write a formula in Excel that performs the following:

If cell A1 contains the text ".png",".jpeg" then cell B1 = Image

If cell A2 contains the text ".mov",".mp4" then cell B2 = Video

And so on...

Also, is it possible to apply this validation with additional validation already applied? Like a list.

Aucun commentaire:

Enregistrer un commentaire