IF SUM and Subtraction

[rlc]

[TABLE="width: 192"]
<COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]ROW[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]X[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl63, width: 64, bgcolor: transparent"]B[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] $ 1.00 [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent"] $ 2.00 [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl65, bgcolor: transparent"] $ 4.00 [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] $ 10.00 [/TD]
[/TR]
</TBODY>[/TABLE]

Quarterly review formula
Formula: =IF(X3=3,IF(SUM(A1:A3)>=B4,SUM(A1:A3),SUM(B4-(A1:A3))))

I am having an issue with the last SUM in this formula. Chances are I am using the wrong function. Thank you for any assistance you can provide

 

[andiemac]

I'm guessing there is more to your question, but at a purely "grammatical" level...

Formula: =IF(X3=3,IF(SUM(A1:A3)>=B4,SUM(A1:A3),B4-SUM(A1:A3)))