How i calculate reverse [sum] formula (for example)

[GURPREET SINGH]

	=A3*30%	=B3*1%	200	=SUM(A3-B3-C3-D3)
BILL VALUE	TAX	SURCHARGE	EXP	PAYOUT
1000	300	3	200	497
861	258.3	2.583	200	400
IF I NEED OF PAYOUT (RS.400) THEN HOW MY BILL VALUE ON SAME TAX RATE, SURCHAGE RATE AND EXPENSE VALUE
FOR EXAMPLE :
BILL VALUE	TAX	SURCHARGE	EXP	PAYOUT
861	258.3	2.583	200	400
HOW CALCULATE RS.(861) BY EXCEL FORMULA

<tbody>
</tbody>

 

[wwbwb]

If it's always 30% and 1%, then it's (payout+exp)/.697 if my math works out.

 

[GURPREET SINGH]

If it's always 30% and 1%, then it's (payout+exp)/.697 if my math works out.

thanx

its work

but please explain how to calculate 0.697

 

[wwbwb]

If you figure this:
x=bill value
your formula is
x -.3x -.1(.3x) - 200 = Payout
Payout + 200 = x(1-.3-.003)
Payout + 200 = .697x
x=(payout+200)/.697

 

[GURPREET SINGH]

thanx

nice explanation