How do I create a certain equation in Excel spreadsheet?
 

I want to set up a box, that already has a value, so that if another box is
in the negative that amount is subtracted from the first box's value but if
it's still positive it won't affect the first box's value.

How do I create a certain equation in Excel spreadsheet?
 

Hi tomscobie,

Say your first cell (box) is A1 and the second is B1, and you want to have
A1 show 10 unless B1 has a -ve value, in which case you want to reduce A1 by
B1's value. A formula you'd put in A1 to do that could be:
=10+MIN(B1,0)


Cheers


"tomscobie" wrote in message
...
I want to set up a box, that already has a value, so that if another box
is
in the negative that amount is subtracted from the first box's value but
if
it's still positive it won't affect the first box's value.