Formula to leep total from returning below zero

  • Thread starter Thread starter johnhanna
  • Start date Start date
J

johnhanna

Hello,
I am a newbie here, so please bear with me.

If the first cell = 2 and the second cell = 4 then the sum would be -2.
I want to have the sum always be a whole number (zero or greater). So
the sum should never be less then zero so 2-4=0.

I want to have one cell subtracted from the second cell, and the total
to not be less then zero, then have a third cell added to the total of
the first two cells.

In my attachment, it is cell AT7 through AT18 that have this function.

Thank you very much in advance for everyones help with this one. It's
probably a simple one, I just cant get it...... :confused:


+----------------------------------------------------------------+
| Attachment filename: sample.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=365472|
+----------------------------------------------------------------+
 
Hi

=FirstCell-IF(FirstCell<SecondCell,FirstCell,SecondCell)+ThirdCell
Use relative references (like A7 or C18) when replacing variables in formula
for one cell, and copy the formula over range you do need it in
 
Back
Top