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