ExcelBanter - If Or functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If Or functions (https://www.excelbanter.com/excel-discussion-misc-queries/114814-if-functions.html)

keyinput

If Or functions

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

CLR

If Or functions

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

roadkill

If Or functions

=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

All times are GMT +1. The time now is 10:40 AM.