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