| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Functions in Excel | Excel Worksheet Functions | |||
| Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
| User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Visible rows and functions that work | Excel Worksheet Functions | |||
Linear Mode
