SE function with 3 final values

Asked

Viewed 72 times

1

---Rephrasing the question---

A formula expressing the following information:

-When Column I and J is written "Letter N" will return in column C the writing "PSI"

-When Column K and L is written "Letter N" will return in column C the writing "SI"

-When Column I , J , K and L is written "Letter N" in all these 4 columns will return in column C the writing "C/D"

OBS: My excel does not have function option SES.

excel function vba excel-vba fórmula

  • but what’s the question? or is it to solve the problem?

  • If possible explain me how the SES function can be replaced because I could not find any function that does this other than the SES function, but where I will apply we do not have this resource available

  • You have to discriminate more precisely the combinations. For example "When it’s not "A" or "B" retouch "C/D"" are you referring to which columns? " A' in column L and "B" in column J or in a single column? Do both conditions have to occur or just one condition? Define precisely what you want, leaving no room for possible interpretations, which will make it easier to help you.

  • the SES function may be replaced by the SE and OU, for example: SE(OU(J1="A";L1="B");"IGUAL";"DIFERENTE")

1 answer

0


Place in cell C1 and copy to the other cells in the column:

=SE(E(I1="N"; J1="N"; K1="N"; L1="N"); "C/D"; SE(E(I1="N"; J1="N"); "PSI"; SE(E(K1="N"; L1="N"); "SI"; "Não é nenhuma das alternativas")))

Browser other questions tagged excel function vba excel-vba fórmula

You are not signed in. Login or sign up in order to post.