What do you mean by 'if it exceeds'?


"arisan" wrote in message
...
hi there!!
Am New to this discussion and its this problem that brought me to this
discussion....

its have got to adjust values in Col E to 30, if it exceeds in Col D where
Col D is sum of A, B and C..... tried alot of rubbish formulae but all in
vain...
can anyone help plz
--
arisan