auto input in next cell

J

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
 
O

oldchippy

just1creation said:
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.
Click to expand...
Hi just1creation,

Try this in L84

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

oldchippy :
 
O

oldchippy

just1creation said:
see attachment
Click to expand...
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 :
 
Top