Search code examples
excelif-statementgoogle-sheetsnested-ififs

Forumula IFS 1*1=1

Im looking for someone to get me a full explanation about what exactly does 1*1=1 in the following formula.

=IFS(L72=I71,"YES",L72=J71,"YES",L72=K71,"YES",1*1=1,"NO")
Solution

  • it doesnt matter what you use if the result will be always true. examples:

    1*1=1
1=1
TRUE
9*9=9
502=502
"x"="x"
16=4*4

    any of them will work