=sum/if questins

[linuxuser]

I am trying to find a formula that will do this.
(sorry cant post the sheet right now)
A1- $56,423.00
A2- $29,589.00
A3- $58,139.00
B1- =sum(A1+A2+A3)
So B1 shows $144,151.00

I want C1 to have a formula that will have if B1 is equal to $100,000 or more to subtract the $100,000 to just show the $44,151.00.
In D1 I want it to show that there was a sum equal to $100,000 exactly with the remainder being shown in C1.

 

[JackDanIce]

Welcome to the board.

I think the two formulae you want are:

C1:

=IF(B1>100,000,C1-100,000,C1)

and D1:

=IF(B1>100,000,100,000,"")

 

[Misca]

Try:

Excel Workbook
	A	B	C
1	$56 423,00	$144 151,00	$44 151,00
2	$29 589,00	*	*
3	$58 139,00	*	*
Sheet

or

Excel Workbook
	A	B	C
1	$56 423,00	$144 151,00	$44 151,00
2	$29 589,00
3	$58 139,00
Sheet

 

[linuxuser]

You guys are soo helpful thank you very much! that worked perfectly! I was surprised how fast I got a response.