=if(j2=d14,1,if(and(j2d14,d14<e14),.5,if(j2e14,0 ,"unknown")))

"CLR" wrote:

This is very similar to your post in WorksheetFunctions group......were none
of those four answers acceptable........if this is the same question but only
that you need additional assistance, you should keep it in the same thread if
possible.

"keyinput" wrote:

I need to get one of three results

If J2=D14,1
if J2D14<E14,.5
if J2E14,0

Can't see to get this to work in an "if or" function