How do I create a certain equation in Excel spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting positive amts from negative and positive from positive 3
Equation Efficiency? 1
if equation 3
how to create an absolute value 3
How do I create the formula for this calculation? 1
How do I make a cell in Excel default to the negative value? 1
subtract a positive from a negative 7
Equation Editor & Excel 2

Back
Top