IF AND statement with multiple outcomes

[Demona26]

Hi All. I feel like there is an easy answer to this one; I've been trying nested formulas but I can't get it right.
I want to do an IF/AND statement that will produce one of 3 outcomes.
This is what the final results should look like: first 2 rows are values. 3rd row is the result I want.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]20%
[/TD]
[TD]50%
[/TD]
[TD]90%
[/TD]
[/TR]
[TR]
[TD]10%
[/TD]
[TD]20%
[/TD]
[TD]10%
[/TD]
[/TR]
[TR]
[TD]NA
[/TD]
[TD]Yes
[/TD]
[TD]No
[/TD]
[/TR]
</tbody>[/TABLE]

Basically I want this: if you subtract the first 2 rows, you will get a result.
If the result is less than 40%, and the value in the first row is less than 40%, return NA
If the result is less than 40% and the value in the first row is greater than 40%, return YES
If the result is greater than 40% and the value in the first row is greater than 40%, return NO

Any help you can provide would be appreciated.

 

[Scott Huish]

=if(a1-a2<0.4,if(a1<0.4,"na","yes"),"no")

 

[Demona26]

=if(a1-a2<0.4,if(a1<0.4,"na","yes"),"no")

Thank you! That's awesome.