Excel formula

[debbie]

Cell M2 has YES. I want to display the content of L2 (35) in N2, if m2 is yes.

 

[CLR]

=IF(M2="yes",N2,"")

Vaya con Dios,
Chuck, CABGx3

 

[Bearacade]

In N2 put this formula in,

=IF(M2="yes", L2, ""

 

[CLR]

Sorry, mis-read........should have been like what Bearacade said....

=IF(M2="yes",L2,"")

Vaya con Dios,
Chuck, CABGx3

 

[Franz Verga]

Nel post *debbie* ha scritto:

Cell M2 has YES. I want to display the content of L2 (35) in N2, if
m2 is yes.

in N2 type:

=IF(M2="YES",L2,"")


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy