| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I add V.A.T (Value Added Tax) to a spread sheet?
Hi, i have been trying to setup a spread sheet for my boss and he want V.A.T
adding to it, and i can't work out how to do this. Can anyone help? |
|
#2
|
|||
|
|||
|
=A1*(1+17.5%)
where A1 is an amount, Or store the rate, 17.5%, in a cell and use that =A1*(1+M1) -- HTH RP (remove nothere from the email address if mailing direct) "Crusty" wrote in message ... Hi, i have been trying to setup a spread sheet for my boss and he want V.A.T adding to it, and i can't work out how to do this. Can anyone help? |
|
#3
|
|||
|
|||
|
Thanks very much! a great help. Get this thing sorted in no time now!
"Bob Phillips" wrote: =A1*(1+17.5%) where A1 is an amount, Or store the rate, 17.5%, in a cell and use that =A1*(1+M1) -- HTH RP (remove nothere from the email address if mailing direct) "Crusty" wrote in message ... Hi, i have been trying to setup a spread sheet for my boss and he want V.A.T adding to it, and i can't work out how to do this. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Idea for an Excel function called "Spread" | Excel Worksheet Functions | |||
| how do I make a new spread sheet pop up, based on an entry in a c. | Excel Discussion (Misc queries) | |||
| Excel window in spread sheet? | Excel Discussion (Misc queries) | |||
| Merging two spread sheets | Excel Worksheet Functions | |||
| how do i compare 2 spread sheets if the content of a cell is avai. | Excel Worksheet Functions | |||
Linear Mode
