novice trying to write formula

[marywatson]

I'm trying to write a formula: If column D = K or any number 1 - 12
and K = A then L = NL ( or I could use the number 1)
Please remember I'm a novice EXCEL user...and what little I know i
self-taught. thanks

 

[Otto Moehrbach]

Mary
It's somewhat difficult to follow what you're saying. Does "column D =
K" mean "column D = column K" or is it "column D = the letter K"? And what
does "K = A" mean? And what does "then L = NL ( or I could use the number
1)" mean? HTH Otto

 

[Fabian]

I'm trying to write a formula: If column D = K or any number 1 - 12

and K = A then L = NL ( or I could use the number 1)
Please remember I'm a novice EXCEL user...and what little I know is
self-taught. thanks.

=if(or(D1=K1,and(D1>=1,D1<=12,K1=A1)),L=NL,false)

That is what you said. Whether it is what you intended or not, I don't
know.