how to calculate original value

[RAMU]

Dear Friends,

in column B i have lots of values which are 26% less than original value, I mean 26% discounted from original value.

I have to chalk out exact value in column C.

As exam in column B i have 74. in column C value will come 100.

Any formula pls help.

Regards

Ramu

 

[Scott T]

Book1
	B	C
1	26%
2	74	100
3	37	50
4	7.4	10
Sheet1

Cell Formulas
Range	Formula
C2	=(B2/(1-$B$1))
C3	=(B3/(1-$B$1))
C4	=(B4/(1-$B$1))

 

[Peter_SSs]

Like this?

Excel Workbook
	B	C
1	Discounted	Full
2	74	100.00
3	26	35.14
4	2356	3,183.78
5	23.25	31.42
Full Value

 

[RAMU]

Dear Sirs,

Thanks to both of you. both are excellent. GR8.

 

[Peter_SSs]

Dear Sirs,

Thanks to both of you. both are excellent. GR8.

You're welcome.