Excel formula
 

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

Excel formula
 

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

Vaya con Dios,
Chuck, CABGx3



"debbie" wrote:

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

Excel formula
 

In N2 put this formula in,

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556543

Excel formula
 

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

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

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"debbie" wrote:

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

Excel formula
 

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