Novice at formulas needs help

[marywatson]

Please remember...I'm a novice at EXCEL...self-taught...I want to write
a formula that will convert what is in one column to another column
based on info in yet another column....
If D=1 and K=B then L=NH...another example...
If D=7 through 12(as in grade in school) and K=D then L=IH

 

[Frank Kabel]

Hi

use the IF formula. E.g. if your target cell is C1 enter the follwoing
=IF(A1="D",B1,"no value")
this will enter the value of B1 in C1 if A1 is "D"

have a look at the Excel helpfile for the IF formula
Frank

 

[Bob Phillips]

=IF(AND(D1=1,K1="B"), "NH","")
=IF(AND(D1>=7,D1<=12,K1="D"),"IH,"")
both are written for L1

to combine

=IF(AND(D1=1,K1="B"), "NH",IF(AND(D1>=7,D1<=12,K1="D"),"IH,""))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)