Help If Statement

[drreamsurfer]

Con you please give me the formula for the following statement

Column L must equal column N only if column K=TRUE if column K=FALS
column L must equal 0.

Thanks

Linse

 

[JE McGimpsey]

See answer to your previous post.

 

[Kevin Sprinkel]

=IF(K1=TRUE,N1,0)

HTH
Kevin Sprinkel