How do I create a certain equation in Excel spreadsheet?

T

tomscobie

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.
 
M

macropod

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
 
Top