It sounds like you want to have the sum in column D show the actual
sum unless that value exceeds 30. If so, the formula would be:
=IF(SUM(A3:D3)30,30,SUM(A3:D3))


On May 8, 9:49 am, arisan wrote:
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