jeudi 14 juillet 2016

Excel Formula For If

Ok. I'm Having A Problem With A formula That Seems Really Basic. It Uses The If Function. Here's What I Need.

If(b2:b50<>"",IF(b2:b50"607734",e2:e50="Patriot"))

So Basically If Between b2-b50 Has The Number "607734" I Want e2-e50 To Display "Patriot"

Aucun commentaire:

Enregistrer un commentaire