discount reverse formula

[Harsoda Prashant]

PLEASE suggest me a formula for MRP i want a reverse discount formula for MRP

 

[Harsoda Prashant]

	A	B	C
1	MRP	DISCOUNT	SELLING PRICE
2	1000	45%	550
3	2000	50%	1000

<tbody>
</tbody>

IN THIS TABLE CELL C2 formula is =A2-(B2*A2)
BUT I WANT TO REVERSE FORMULA FOR THIS MEANS FORMULA FOR CELL A2 MEANS WHEN I'AM FILL B2 AND C2, A2 IS ANS

 

[codeedoc]

Selling price / 1 - .45

 

[asad]

Try

=C2/(1-B2)

Same as codeedoc, I just used cell reference instead of field name

 

[Harsoda Prashant]

It's working thank you so much