help with excel..

[M8XY G]

i need use a percentage as an absolute reference.

What formula do i use to get 10% of £12 but use the 10% as an absolute reference?

We'll say 10% is in C3 and £12.00 is in cell C6

Discount Factor= 10%

Item Normal Price Discount Price
A £12.00

 

[welsh182]

=c6-(c6*$c$3)

 

[M8XY G]

cheers thanks man