vendredi 25 janvier 2019

If last number from first group is x then

In excel i'm looking to do the following.

example I have a cell G19 that contains the following (N2640001 Km0,800) without the brackets In another cell I want to display O or A depending on the value of the last number from the first part. So in this example the first part is ending in 1 so the value in my other cell should be O If the first part would end in 2 the value needs to be A

Aucun commentaire:

Enregistrer un commentaire