help with excel formula

[Guest]

Worksheet for assigning training courses based on Need 1 (-3,-4,-5)
and Need 2 (-1,-2)
Need 1 formula : =IF(F10,=-3,T(A70:A70),IF(F10>=-2,T("")))
Need 2 formula : =IF(F10,=-2,T(A71:A71),IF(F10<=-2,T("")))
Desired result:
If the value in F10 is -3 or-4 or -5 then enter text from A70, if not, then
blank cell
If the value in F10 is -2 or -1 then enter text from A71, if not, then blank
cell
If the value in F10 is 0 or 1 or 2 then no text in either cell or "N/A"

Any suggestions ???

 

[Alan]

=IF(OR(F10=-3,F10=-4,F10=-5),A70,"")
=IF(OR(F10=-2,F10=-1),A71,"")
Regards,

 

[Bob Phillips]

Is this meant to be all one test in one cell, or many cells? I ask as the
first test says blank if not -3, -4 or -5, but the second tests other
values.

 

[Guest]

Hi,
Tr
=IF(OR(F10={-3,-4,-5}),A70,(IF(OR(F10={-2,-1}),A71,IF(OR(F10={0,1,2}),"","N/A"))))