Looking for formula that will subtract when bottom number is larger than top number

[Robert Wyatt]

I have had this up before and I'm sorry for bringing it back again, but I need to have a formula that will subtract if the bottom number is larger than the top. Let's say B6 is 840.00 I would need to have the formula subtract the bottom number from the top to show how much I'm over the limit of the annual amount

Book1
	A	B	C
1	Social Security Monthy/Annully	Gross Wages	Amount
2	Allowed Monthly		$ 1,770.00
3	Estamited Monthly	$ 798.48	$ 1,596.96
4	Difference		$ 173.00
5	Allowed Annually		$ 21,240.00
6	Estamited Annually	$ 798.48	$ 20,760.48
7	Difference		$ 480.00
Sheet1

Cell Formulas
Range	Formula
C2	C2	=ROUND(SUM(C5/12),2)
C3	C3	=IF(B3=0,0,ROUND(SUM(B3*2),2))
C4,C7	C4	=IF(OR(C3=0,C2=0),0,ROUND(IF(C3>C2,0,C2-C3),+ROUND(IF(C3<C2,0,C2-C3),2)))
C6	C6	=IF(B6=0,0,ROUND(SUM(B6*26),2))

 

[Joe4]

Do you mean something like this?

=IF(B6>B3,B6-B3,0)

or simply just:

=MAX(B6-B3,0)

Also, note that your SUM functions in these part of your formulas are not needed:
SUM(C5/12)
SUM(B3*2)
SUM(B6*26)

To use the SUM function on a single cell serves no purpose whatsover, and can be eliminated, i.e.
C5/12
B3*2
B6*26

The SUM function is used to sum up a RANGE of cells, i.e.
SUM(A3:D3)
would be equivalent of:
A3+B3+C3+D3

I also often see people use SUM and addition in the same formula, which is redundant, and unneccessary.
So for the formula above, I often see:
SUM(A3+B3+C3+D3)

You only need one or the other (SUM function OR each +, not both), like I show above.