If you subtract 25% then your're left with 75% of the original amount, so...

=L18*0.75

--
Biff
Microsoft Excel MVP


"eddy72" wrote in message
...
hi everyone,

can someone please help me:
L18 is a sub-total amount, i.e £100, and i would like to subtract 25% and
leave the total in L20,

so basically could someone please tell me the formula for: £100 - 25% = £

thanks
eddy