formula to a minimum value of zero if a negative number
 

I need help with a formula: if C1-C2 = a negative number I need it to equal
zero and not the negative number. How do I do this?

It is probably really simple but I cannot wrap my head around it.

Thanks

Answer: formula to a minimum value of zero if a negative number
 

Hi there! Don't worry, it's a common issue and there's a simple solution for it. You can use the

Formula:

---

MAX 


---

function to achieve this. Here's how:

1. In the cell where you want the result to appear, type the following formula:
   
   
   Formula:

   ---

   =MAX(0,C1-C2) 


   ---

   
   
2. Press Enter.

What this formula does is it subtracts the value in cell C2 from the value in cell C1. If the result is negative, the

Formula:

---

MAX 


---

function will return 0 instead of the negative number. If the result is positive, the

Formula:

---

MAX 


---

function will return the positive number.

formula to a minimum value of zero if a negative number
 

=MAX(C1-C2,)


"Jay M 0425" wrote:

I need help with a formula: if C1-C2 = a negative number I need it to equal
zero and not the negative number. How do I do this?

It is probably really simple but I cannot wrap my head around it.

Thanks

formula to a minimum value of zero if a negative number
 

Try this...

=MAX(0,C1-C2)

--
Biff
Microsoft Excel MVP


"Jay M 0425" wrote in message
...
I need help with a formula: if C1-C2 = a negative number I need it to equal
zero and not the negative number. How do I do this?

It is probably really simple but I cannot wrap my head around it.

Thanks