Need help with excel

by banaan • 25 Apr 2007, 10:49 • Journals
Well i forgot how to math 19% btw and stuff



=som(........)


:'>
Comments
13
▼
Gibri 25 Apr 2007, 11:55
hu?

RTFM!
▼
Deactivated7001 25 Apr 2007, 12:17
he? 19 per cent of 25 are = 25/100*19 for example. Did you mean that?
▼
banaan 25 Apr 2007, 12:21
Something like this


field F7 is 100


and it asks me the 19% btw if ut


=som(F7:100*19)

But i'm not sure the formula works need excel:<
its for school =>
Parent
▼
Deactivated7001 25 Apr 2007, 12:23
just =F7/100*19 imo
Parent
▼
banaan 25 Apr 2007, 12:27
Nice thanks

and this formula

=som(F7*0.19)


19% does that work or

just

=F7/100*19
Parent
▼
TrgT 25 Apr 2007, 12:34
You'll have to take 1.19 if you need more money, if your giving a discount you'll have to use a 0. figure If you want "more" money you'll have to use 1.
Parent
▼
eXoz 25 Apr 2007, 12:24
example: the number where you have to count btw on is: A1

A1= 100 B1=som(A1*1,19)
▼
incucuna 25 Apr 2007, 13:32
i think function som is only for addition

A1=100
B1=200

=som(A1;B1) --->300
▼
Hope 25 Apr 2007, 14:18
Ha, just finished my Excel course yesterday with some easy test xD
▼
kiss 25 Apr 2007, 15:13
Or you choose a field with 0.19
Then you can just do F7 x FIELD0.19
Back to top