Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
=L18*0.75
HTH Regards, Howard "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage
On Sep 9, 6:40�am, 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% = � I think you need to understand more about basic maths before using spreadsheets. Your local council (like most councils) is currently advertising courses for this sort of education, which can be free for some people. Ask at your local council offices, ask for "Further Education" or "Adult Education". Alan Lloyd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage | Excel Worksheet Functions | |||
percentage | Excel Discussion (Misc queries) | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Percentage | Excel Discussion (Misc queries) | |||
Bar Chart depicting the "percentage of another percentage(less than 100)" | Charts and Charting in Excel |