If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
is there a formula for working out vat without repeating *17.5%
I know the formula for working out vat i.e =*17.5% is there a repeat formula
for cells to work out vat automatically , a am using excel. |
#2
|
|||
|
|||
is there a formula for working out vat without repeating *17.5%
I don't know of a formula but you can try this to see if it makes
calculating the VAT faster type 17.5% in a blank, unused cell. click copy highlight the area where you want to calculate the VAT (for instance if you want to multiply all of column B by 17.5%, hightligth all of column B) Go to Edit-PAste Special - select multiply and formulas (so you don't change the formatting unintentionally) and hit ok Everything that you highlighted will not by multiplied by 17.5%. Alternatively.... you could use the product function. On Jul 25, 9:32*am, monalisa wrote: I know the formula for working out vat i.e =*17.5% is there a repeat formula for cells to work out vat automatically , a am using excel. |
#3
|
|||
|
|||
is there a formula for working out vat without repeating *17.5%
You'd just use the formula =Cell_ref * .175 and then copy it down your list
of values. Maybe I'm not understanding something right. -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "monalisa" wrote: I know the formula for working out vat i.e =*17.5% is there a repeat formula for cells to work out vat automatically , a am using excel. |
#4
|
|||
|
|||
is there a formula for working out vat without repeating *17.5%
Possibly even more intuative is
Select a cell then Insert|Name|Define and call it VAT Enter 17.5% in the named cell You can then use formula like =C1*Vat To work out the VAT on C1 Mike "monalisa" wrote: I know the formula for working out vat i.e =*17.5% is there a repeat formula for cells to work out vat automatically , a am using excel. |
#5
|
|||
|
|||
is there a formula for working out vat without repeating *17.5%
Stick the 17.5 in a cell then refer to that in your formulas.
Assumes 17.5 is in D1 Numbers are in Column A In B1 enter =A1*$D$1 Double-click on the fill handle of B1 to copy down column B The A1 will increment but $D$1 will remain the same. Gord Dibben MS Excel MVP On Fri, 25 Jul 2008 06:32:02 -0700, monalisa wrote: I know the formula for working out vat i.e =*17.5% is there a repeat formula for cells to work out vat automatically , a am using excel. |
Thread Tools | |
Display Modes | |
|
|