Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you apply criteria in order of preference?
For example:
1.If bad number is submitted 2. If any score is 500 3.If any score is below 100 4. If two column's average 200... I can do the formula's to give the above information but I do not know how to apply the above in order of preference as in 1, 2, 3, 4 (above) Thanks for any help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you apply criteria in order of preference?
One way;
=IF(NOT(ISNUMBER(TEST)),"Entry error",IF(TEST=500,"SCORE = 500",IF(TEST<100, "Score is less than 100",IF(AVERAGE(TEST)=200,"Average is 200","Something Else")))) *Note that excel has a limit of seven nested statements. Hope this helps. DK "DLL" wrote in message ... For example: 1.If bad number is submitted 2. If any score is 500 3.If any score is below 100 4. If two column's average 200... I can do the formula's to give the above information but I do not know how to apply the above in order of preference as in 1, 2, 3, 4 (above) Thanks for any help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you apply criteria in order of preference?
Hi,
are you writing a formula, creating a criteria for a filter, or creating a conditional format or data validation? Or maybe you are writing a macro? What do you mean by order of preference? if bad number is submitted what do you want to do. And what do you want to do if each of the three other conditions succeed or fail? What version of Excel are you using? -- If this helps, please click the Yes button. Cheers, Shane Devenshire "DLL" wrote: For example: 1.If bad number is submitted 2. If any score is 500 3.If any score is below 100 4. If two column's average 200... I can do the formula's to give the above information but I do not know how to apply the above in order of preference as in 1, 2, 3, 4 (above) Thanks for any help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you apply criteria in order of preference?
=IF(OR(NOT(ISNUMBER(A1)),A1=500,AVERAGE(A2,B2)<200 ,A1<100),"False",A1)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to apply date range criteria | Excel Worksheet Functions | |||
Print preference changes when e-mailed - WHY | Excel Worksheet Functions | |||
printing preference | Excel Discussion (Misc queries) | |||
How come I need to enter a cell in order for the formatting to apply correctly??? | Excel Discussion (Misc queries) | |||
how to disable ms exchange as email preference | Excel Discussion (Misc queries) |