spreadsheet help

spookywillow

spookywillow

spookywillow

Soldato
Joined
3 Mar 2006
Posts
3,233
Location
Atcham, Shropshire
i'm trying to calculate some percentages for a coloumn but forgot the formula i used and forgot the site i got it off lol, spent all morning trying to figure it out and im stumped.

basically i have a coloumn F3 to F236, all fields in that coloumn need 50% added to them and then rounding up to the nearest £.

i'm pretty sure my formula was something along the lines of

=F3:F236*1.50

but it wont work :(
 
You want something like this (in cell G3):

=F3*1.5

That means that G3 is now 1.5 * what ever is in F3.

You can apply the formula to the rest of column G, by highlighting G3 and the cells below it at the same time. Then use Edit - Fill - Down to apply the formula to the cells you highlighted.

Alternatively if you select G3, then the black square in the bottom right-hand corner of the black-highlight-box, can be used in a 'drag-and-drop' fashion to apply to the cells below.

To get the formula to always give the nearest pound, then you'd need to change it to the following:

=ROUND(F3*1.5,0)

If you want to get it to always round up to the next whole pound, then use:

=ROUNDUP(F3*1.5,0)

Again, after changing the formula in G3, you'd have to apply it to the cells below, in the same way as before.
 
cheers, the percentage one works ok but the roundup one doesn't, just leaves #NAME? in the field. any ideas?

last time i did this i used Special paste but that wont work now either :(
 
For future reference, you obviously don't have Roundup installed in your version of Excel.

Instead of RoundUp use:
=ROUNDUP(F3*1.5+0.5,0)
 
You must log in or register to reply here.
Back
Top Bottom