how do i make this work (if N2 = "Yes" then O2 = L2)

kelli4169 · Aug 20, 2004

how do i make this work?
(if N2 = "Yes" then O2 = L2)

NH · Aug 20, 2004

On cell O2 type

=if(n2="yes",L2)

Frank Kabel · Aug 20, 2004

Hi
in O2:
=IF(N2="Yes",L2,"")

Multiple IF's with an OR	5	Jun 4, 2010
use cell address	1	Jun 23, 2011
combining multiple columns using ", " seperations..	4	Sep 29, 2009
Help Writing a SUM Formula	5	Jul 25, 2012
Dates	4	Sep 14, 2009
Filling formulas with specific cell references remaining the same	2	Mar 25, 2010
Formula returning an error	2	Jan 4, 2010
Easier way to concatenate a row?	8	Oct 21, 2008

Ask a Question