Excell???? OK I'm Dim

[j.m@talk]

I need a formula to calculate my VAT :( (value added tax......kinda like gst)

Anyways I'mm too stoopid & the girls off.........


Vat rate @ 17.5%

Anyone?????????????? :-@ :-@ :-@

just somthing to add 17.5% to a sub total will work a treat :-@

[BipolarBill]

Have you tried n + 17.5%?

[j.m@talk]

did say I was dim :(

so I just slap in n + 17.5% with the spaces & everything .......

[BipolarBill]

No. Gawd I hate Excel and all numerical ****. I can never remember this dry stuff.

http://homepage.cs.uri.edu/tutorials/csc101/pc/excel97/formula.html

[j.m@talk]

Gee I hate readin ;)

Cheers bill :)

[Midknyte]

=(cell1+cell2+......)*1.175

[Strawbs]

I hate Excel too ...but I figured it out!

:t

[edit] that sould read ADD COLUMNS 'A' AND 'C' FOR SUM not A & D. :eek:

[j.m@talk]

guess what?


I've left something out :(

Yeah OK ........................OK........................ ...... umm


somone pm me & I will wizz over the very small spead sheet so they can doctor it for me :( :( :(

Gawd I hate math

[j.m@talk]

Hey strawbs I never thought of that ............. sep coloum....ummm

[Strawbs]

This is Midknyte's route!

[j.m@talk]

That looks like the way to go ! :)

Still ya dont fancy doing it do you ? ;)

Yes works
:D

[rraehal]

To figure a percentage of a value in excel you can do several things:

The percentage by itself:
=CELL*%
Say Cell B4 is $100.00
Say Cell C4 has the percent 6.00%
The calculating would be =B4*C4
The result would be $6.00

The percent added to the value from example above:
=(B4*C4)+B4
The caluculation would be (100*6)+100 = (6)+100
The total would be $106.00

You must follow typical Orders of Operations for math
Powers
Parenthases
Multiplication
Divison
Additon
Subtraction

In this example excel will figure like this:
=6^2+(3*5+2)/(6-2)
36+(15+2)/(4)
36+17/4
36+4.25
40.25

=6^2+2*4*(6+1)/6
36+8(7)/6
36+56/6
36+9.333
45.333

You must plan exactly how you want excel to calculate and group with parenthases

[Bigjakkstaffa]

Dont talk to me about excel, last year i had to so some stuff with it involving VB scripts (oh what a hoot, i hate programming), making formulas that imported data from cell references from other sheets and the like. Talk about boring and confusing..

For that all you would have to do is

=SUM(cell reference of original value here*1.175)

then copy it, select the entire column, and paste. Thus it should autocalculate the values for you

--Jakk:t

[G]

The formula is as follows where X is your initial value.

X * (17.5/100) =

Or

X*0.175 =

This will give you the value of the VAT only.

To find the total including VAT

X * (117.5/100) =

Or

X * (1.175) =

To do this in Excel, see above posts if correct.

G

[Strawbs]

I'm gonna start a crusade! :x

[DocEvi1]

Lol, I love excel and the VB beside it, you still having trouble j.m?

Stefan

[DocEvi1]

=a1+(a1/100*17.5)

will calculate the tax for a1

Stefan