| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Amount minus VAT
If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT.
I need to enter different amounts in A1, A2 etc. all way down the A Column and show in the B Column Less 15% VAT. Any help would be much apreciated. -- Snowyhjt |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount minus VAT
=A1-(A1*0.15)
If this post helps click Yes --------------- Jacob Skaria "SnowyHJT" wrote: If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT. I need to enter different amounts in A1, A2 etc. all way down the A Column and show in the B Column Less 15% VAT. Any help would be much apreciated. -- Snowyhjt |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount minus VAT
Hi,
Try =(A1/115)*100 Mike "SnowyHJT" wrote: If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT. I need to enter different amounts in A1, A2 etc. all way down the A Column and show in the B Column Less 15% VAT. Any help would be much apreciated. -- Snowyhjt |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount minus VAT
Jacob,
Are you sure, isn't that just 15% of the total including VAT? Try adding back 15% and you don't get back to the original number. Mike "Jacob Skaria" wrote: =A1-(A1*0.15) If this post helps click Yes --------------- Jacob Skaria "SnowyHJT" wrote: If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT. I need to enter different amounts in A1, A2 etc. all way down the A Column and show in the B Column Less 15% VAT. Any help would be much apreciated. -- Snowyhjt |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount minus VAT
Ooops...You are right...Thanks Mike...
Let me go and sleep... If this post helps click Yes --------------- Jacob Skaria "Mike H" wrote: Jacob, Are you sure, isn't that just 15% of the total including VAT? Try adding back 15% and you don't get back to the original number. Mike "Jacob Skaria" wrote: =A1-(A1*0.15) If this post helps click Yes --------------- Jacob Skaria "SnowyHJT" wrote: If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT. I need to enter different amounts in A1, A2 etc. all way down the A Column and show in the B Column Less 15% VAT. Any help would be much apreciated. -- Snowyhjt |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount minus VAT
Thank you Jacob, a great help
-- Snowyhjt "Jacob Skaria" wrote: =A1-(A1*0.15) If this post helps click Yes --------------- Jacob Skaria "SnowyHJT" wrote: If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT. I need to enter different amounts in A1, A2 etc. all way down the A Column and show in the B Column Less 15% VAT. Any help would be much apreciated. -- Snowyhjt |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount minus VAT
Thank you Mike, it worked great
-- Snowyhjt "Mike H" wrote: Hi, Try =(A1/115)*100 Mike "SnowyHJT" wrote: If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT. I need to enter different amounts in A1, A2 etc. all way down the A Column and show in the B Column Less 15% VAT. Any help would be much apreciated. -- Snowyhjt |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Amount minus VAT
Sorry. Use the formula in Mike's post...=(A1/115)*100
If this post helps click Yes --------------- Jacob Skaria "SnowyHJT" wrote: Thank you Jacob, a great help -- Snowyhjt "Jacob Skaria" wrote: =A1-(A1*0.15) If this post helps click Yes --------------- Jacob Skaria "SnowyHJT" wrote: If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT. I need to enter different amounts in A1, A2 etc. all way down the A Column and show in the B Column Less 15% VAT. Any help would be much apreciated. -- Snowyhjt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change all cells from minus to plus and plus to minus | Excel Worksheet Functions | |||
| Equation for amount minus the percentage. | Excel Discussion (Misc queries) | |||
| Need the minus amount to show | Excel Discussion (Misc queries) | |||
| CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
| how to color code a cell in excel if amount reaches a minus | Excel Discussion (Misc queries) | |||
Linear Mode
