Conditional Calculated column in a list

[Tusk]

Hi All,

I'm trying to construct a list in MOSS 2007 to track Risks. Part of this is to calculate the risk score which is ok, but the next bit is proving tricky. I want to be able to allocate a High, medium and Low to a status column depending on the risk score. I can get it to do a 'medium' and 'low', but am having trouble getting it to do the 'high' as well. Here's my code so far:

=IF(AND([Risk Score]<=12, [Risk Score]>=8), "MEDIUM", "LOW")

I can't seem to get the 'high' bit to work. Any one any ideas on this?

Thanks

Tusk

 

[Tusk]

Have solved my own problem Simple really, trying to be too complicated!

=IF([Risk Score]>11,"HIGH", IF([Risk Score]>7, "MEDIUM,"LOW"))

That does the trick.