Calculating a 100% price increase and round up to the nearest 25p

**uglyduck** · 04-16-2010, 06:42 AM

Hi Guys
I have a huge spreadsheet with products that have a purchase price on the spreadsheet.
If the purchase price in Column Q is 1.29. What is the formula that I need to input that will increase column Q by 100% and then round it up to nearest 25p .
So this example would be 2.58 but would need to be rounded up to 2.75.
Any help would be appreciated.
Thanks
Neil

**DonkeyOte** · 04-16-2010, 06:48 AM

Assuming you're using an adjacent cell to store the revised amount

=CEILING(Q1*(1+1),0.25)

where Q1 holds 1.29

**uglyduck** · 04-16-2010, 07:03 AM

Hi Donkeyote, thanks so much, that works great.
How would I be able to copy this down 20000 cells without dragging down manually please.
Is there an easy way please?
Thanks
Neil

**arthurbr** · 04-16-2010, 07:10 AM

Yes,
enter in the desired cell and double click the handle at the bottom right corner of this cell when it is selected

**uglyduck** · 04-16-2010, 07:12 AM

Hi
thanks for that but due to size of spreadsheet it only fills in a certain amount of cells and then stops. I have to manually double click all the time. Not all cells are filled in so I just need to the column selecting. IS there any way I can select cells 3 to 20346 of Column Q for instance?
Thanks
Neil

**DonkeyOte** · 04-16-2010, 07:17 AM

highlight the formla in Q3, copy it, now type into the box above A1 Q3:Q20346 (or R if as presumed this is where the formula is going) then Edit -> Paste Special -> Formulas

or

enter Q3:Q20346 (or R if as presumed this is where the formula is going) above A1, then in Q3 (R3?) enter the formula and confirm with CTRL + ENTER rather than just Enter.