auto input in next cell

[just1creation]

this is the formula in cell L84
=D84+G84+J84

but if i enter a value in K84 then i would like L84 to change to tha
value

 

[oldchippy]

this is the formula in cell L84
=D84+G84+J84

but if i enter a value in K84 then i would like L84 to change to tha
value.

Hi just1creation,

Try this in L84

=IF(K84<"",K84,D84+G84+J84)

oldchippy :

 

[just1creation]

see attachmen

+-------------------------------------------------------------------
|Filename: untitled.zip
|Download: http://www.excelforum.com/attachment.php?postid=5233
+-------------------------------------------------------------------

 

[oldchippy]

see attachment

Ok,

I've had another look at this and suggest you try these,

in K10
=IF(SUM(D10+G10+J10)<25,25,0)

in L10
=IF(SUM(D10+G10+J10)<25,25,D10+G10+J10)

Does this sort your problem?

oldchippy :