Hi All

I am currently using the below if formula, to alert me when a delivery to one of the stores is over a certain size. 

=IF(C3="Exeter",IF(D3>=10,"Alert",""),"")
I have been tring to make the formula apply to 6 different stores, with out the need to edit each time, the stores also have different criteria

Poole >=4
Barnstaple >=12
Paignton >=4
Taunton >=10
Bridgwater >=10
Exeter >=10

any help with this would be great

kind regards
colin