I cant solve this simple math using excel. Please assist.

[hdjc]

Shifted to commercial forum

[davesexcel]

Please Login or Register  to view this content.

[alansidman]

Maybe this way:

Data Range

	A	B	C	D	E	F	G	H
1	Puchase price			Cash	400000		Cash	Tax1
2	Tax1:	0.03					1	0.01
3	Tax2:	0.12					179999	0.02
4	Max Purchase	347826.1					359999	0.03
5							999999	0.04

Data Range

	A	B	C	D	E	F	G	H
1	Puchase price			Cash	400000		Cash	Tax1
2	Tax1:	=VLOOKUP(E1,$G$2:$H$5,2,TRUE)					1	0.01
3	Tax2:	0.12					179999	0.02
4	Max Purchase	=E1/(1+B2+B3)					359999	0.03
5							999999	0.04

[davesexcel]

Why would this be shifted to Commercial services after it was already answered?

[alansidman]

Dave
I believe the OP moved it to CS before either you or I answered. Looks like OP changed his mind at 12:24 and we answered after that. HE really didn't give it much time for an answer before deleting the question.