| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula
I need to determine one answer for a question that has several possible
scenarios. =IF(OR(C68=4,C68<=7),3,"0") =IF(OR(C84=4,C84<=7),2,"0") =IF(OR(C841,C84<=3),1,"0") If none of the above are true, then the score would be 0. |
|
#2
|
|||
|
|||
|
What if C68 is 5 and C84 is 5, has C68 precedence?
then you can use =IF(C68<=7,3,IF(AND(C84<=7,C84=4),2,IF(AND(C84<=3 ,C841),1,0))) if you meant =4 for C68 =IF(AND(C68<=7,C68=4),3,IF(AND(C84<=7,C84=4),2,I F(AND(C84<=3,C841),1,0))) Regards, Peo Sjoblom "soxn4n04" wrote: I need to determine one answer for a question that has several possible scenarios. =IF(OR(C68=4,C68<=7),3,"0") =IF(OR(C84=4,C84<=7),2,"0") =IF(OR(C841,C84<=3),1,"0") If none of the above are true, then the score would be 0. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Linear Mode
