If...then...else Help
=IF(AND(P13=A1,P13<=B1),D1,IF(AND(P13=A2,P13<=B2 ),D2,FALSE))
"Angela" wrote:
Hello,
I'm trying to find the correct value for P14.
If P13=A1 and <=B1 Then P14=D1
Else
If P13=A2 and <=B2 Then P14=D2
I have alot of numbers to go thru, is there an easy way to do this?
Any help would be greatly appreciated
Thank You
Angela
|