Thread: Percentage
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Percentage

=A1-(A1*25%)
OR
=A1*75%

If this post helps click Yes
---------------
Jacob Skaria


"eddy72" wrote:

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