samedi 2 janvier 2021

Excel conditional formatting that returns a value

I am currently working on an excel project. I came across this specific issue where if cell A1=" Achieved" then cell A2 = "1" else cell A2=" 0". My question is can it be done without using the If Else statement? I tried using the If Else statement but with formula I cannot get the sum total of the column.

Excel value form

Aucun commentaire:

Enregistrer un commentaire