spreadsheet help

[spookywillow]

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

 

[spookywillow]

sorted the percentage just need to figure out the roundingup.......wish i listened at school when we did this years ago lol

 

[spookywillow]

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

 

[spookywillow]

sorted it, just did the one calulation first then rounded up afterwards, cheers for the help