This discussion is closed.
#1
hi im stuck on formula can anybody help i want to add 15% to the total eg total £247 then add 15% and i carnt remember how to do it please help.
0
15 years ago
#2
sum(a1:a4)/100*percentage

I find that is the best way of doing it.

where a1: is the first column etc
0
15 years ago
#3
sum(a1:a4)/100*percentage

I find that is the best way of doing it.

where a1: is the first column etc
.. and another thread bites the dust lol.
0
15 years ago
#4
or just do sum()*1.15 (basically times 1 + 15%)
0
#5
oh thanks people now i might be able to get on i got loads of screen dumps to do as well im told. any advice for getting a realy good score like an A as i need the points to carry on next year and i realy need a good pass. thanks again for the help tho.
0
15 years ago
#6
You doing the AVCE? To get an A make sure you have some VB forms in there, macros and complex formular i.e IF statements.
0
15 years ago
#7
sorry to hijack the thread but does anyone know how to open a VBA userform straight away when the worksheet is opened, i have forgotten what my teacher told me yesterday.
0
#8
You doing the AVCE? To get an A make sure you have some VB forms in there, macros and complex formular i.e IF statements.
the spreadsheet is in excel and im not sure about VB forms and if statements can you explain more so i can read up on this and find info please
0
15 years ago
#9
If this is for AVCE if I remember correctly you need to use VBA to get an A in it.

The easiest way to this is to have input forms (like access) for data entry, it just looks more profesional than entering text into cells. You will need to read up on VBA for Excel.
0
X
new posts
Back
to top
Latest
My Feed

### Oops, nobody has postedin the last few hours.

Why not re-start the conversation?

see more

### See more of what you like onThe Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

### Poll

Join the discussion

Rock (220)
23.63%
Pop (231)
24.81%
Jazz (35)
3.76%
Classical (56)
6.02%
Hip-Hop (174)
18.69%
Electronic (62)
6.66%
Indie (153)
16.43%