Help With Formula

[VinceF]

Greetings,

This formula is not working. A suggestion on how to make it work or a different formula that works would be much appreciated.
Both J38 & K12 could equal 1 thru 10

=IF($J$38={1,2,3,4,5,6,7,8,9,10},IF($K12={1,2,3,4,5,6,7,8,9,10},TRUE,FALSE))

Thank You
VinceF
Office 2016

 

[JGordon11]

=IF(SUMPRODUCT(--($J$38={1,2,3,4,5,6,7,8,9,10})),IF(SUMPRODUCT(--($K12={1,2,3,4,5,6,7,8,9,10})),TRUE,FALSE))

 

[AhoyNC]

A little shorter option.
=IF(SUM((AND($J$38>0,$J$38<11))*(AND($K$12>0,$K$12<11)))=1,TRUE)

 

[Fluff]

Another option

=AND(OR($J$38=ROW($A$1:$A$10)),OR($K12=ROW($A$1:$A$10)))

 

[VinceF]

A little shorter option.
=IF(SUM((AND($J$38>0,$J$38<11))*(AND($K$12>0,$K$12<11)))=1,TRUE)

Thank you all for the formulas, all 3 of them worked but I went with this one...very much appreciated
VinceF

 

[Fluff]

Glad we could help & thanks for the feedback.

You could also shorten that formula as there is no need for the IF.

=SUM((AND($J$38>0,$J$38<11))*(AND($K$12>0,$K$12<11)))=1

 

[djclements]

AND slightly shorter (pun intended)...

=AND($J$38>0,$J$38<11,$K$12>0,$K$12<11)