Hi,

I know I've seen questions about this before but haven't got time to search.

Would any kind soul please tell me how I can get excel to look at a value in
column M and if it is larger than 12 use 12 in that column
--
Smudge