Apr 15 2022 06:43 AM
I want to change the cells with the text "male" in "M" and the cells with the text "female" in "F" and the other cells in X. But I can't. What is the problem with this formula?
=IFS(A1=male,M,A1=female,F,true,X)
Apr 15 2022 07:04 AM - edited Apr 15 2022 07:11 AM
@Mirela1993 On Excel 2019 or later.
Apr 15 2022 08:17 AM
@Mirela1993
As variants
=IFS( A1= "male", "M", A1="female", "F", TRUE, "X") =IF( OR( A1 = {"male","female"} ), UPPER( LEFT(A1) ), "X")