Need a formula to show the difference

[Jdog12]

I have a spreadsheet for bonus, and employees fill out the forms if they elect to pay additional taxes (FIT and SIT), no additional tax or they want to elect fixed amounts for FIT and SIT.

Bonus is taxed at 22% for Federal tax (FIT) and 6.6% for state (SIT). For those employees who elect to pay additional taxes, that's not an issue.

Some employees elect to pay a flat FIT and flast SIT. But on occassions what they put down for the flat FIT and SIT are lower than the required FIT and SIT.

I want to set up two columns to show the differences of what are required for FIT and SIT for those who prefer fixed amounts.

For columns G & H , not all the cells need to be filled out. It could be blank or with numbers.

I tried if statements using And/OR, but i could not get it right.

Any help is appreciated.

 

[awoohaw]

I'm a little confused, but here is my guess at what you want:

Mr excel questions 58.xlsm
	B	C	D	E	F	G	H	I	J
1		0.22	0.066					Warning
2	Employees	FIT 22%	SIT 6.6%	Additional FIT	Additional SIT	FLAT FIT to Replace Statutory FIT Calculation	FLAT SIT to Replace Statutory SIT Calculation	Less than required FIT	Less than required SIT
3	1234	3,300.00	990.00			2,500.00		800.00
4	5678	10,340.00	3,102.00		200.00
5	2678	14,300.00	4,290.00				4,000.00		290.00
6	6266	19,800.00	5,940.00
Jdog12

Cell Formulas
Range	Formula
C3:C6	C3	=A3:A6*C1
D3:D6	D3	=A3:A6*D1
I3:J6	I3	=IF(G3="","",IF(G3>C3,"",C3-G3))
Dynamic array formulas.

 

[Jdog12]

I'm a little confused, but here is my guess at what you want:

Mr excel questions 58.xlsm
	B	C	D	E	F	G	H	I	J
1		0.22	0.066					Warning
2	Employees	FIT 22%	SIT 6.6%	Additional FIT	Additional SIT	FLAT FIT to Replace Statutory FIT Calculation	FLAT SIT to Replace Statutory SIT Calculation	Less than required FIT	Less than required SIT
3	1234	3,300.00	990.00			2,500.00		800.00
4	5678	10,340.00	3,102.00		200.00
5	2678	14,300.00	4,290.00				4,000.00		290.00
6	6266	19,800.00	5,940.00
Jdog12

Cell Formulas
Range	Formula
C3:C6	C3	=A3:A6*C1
D3:D6	D3	=A3:A6*D1
I3:J6	I3	=IF(G3="","",IF(G3>C3,"",C3-G3))
Dynamic array formulas.

I had a space inside of "", and that's why it was showing the value of C4 in I4 when I4 is blank.

My bad!

Thanks,

 

[awoohaw]

I'm happy you figured it out, Best Wishes!