| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add formula to a column of numbers
Basic question Im sure.
I have a list of numbers 23456 45677 34567 etc. and I want to use this formula on them. =CEILING(#####,100) How can I easily add the format or formula (what ever it is called) to the whole list eg so the column looks like this. =CEILING(23456,100) =CEILING(45677,100) =CEILING(34567,100) When I put the fomula in the first line and then drag the corner of this cell down , it just copies the first line over the others and does not add the formula to each line. =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) Thanks Im sure this is basic. Im using XL 97 Regards |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add formula to a column of numbers
Try
=CEILING(A1,100) and copy down. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "steve" wrote in message oups.com... Basic question Im sure. I have a list of numbers 23456 45677 34567 etc. and I want to use this formula on them. =CEILING(#####,100) How can I easily add the format or formula (what ever it is called) to the whole list eg so the column looks like this. =CEILING(23456,100) =CEILING(45677,100) =CEILING(34567,100) When I put the fomula in the first line and then drag the corner of this cell down , it just copies the first line over the others and does not add the formula to each line. =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) Thanks Im sure this is basic. Im using XL 97 Regards |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add formula to a column of numbers
Say your data is in A1:Axxxx
Then put your formula in B1 =ceiling(a1,100) and drag down that column. Excel will adjust that A1 reference to point at the cell in the same row. If you want you can hide Column A or you could select column B edit|copy edit|paste special|values and delete column A. steve wrote: Basic question Im sure. I have a list of numbers 23456 45677 34567 etc. and I want to use this formula on them. =CEILING(#####,100) How can I easily add the format or formula (what ever it is called) to the whole list eg so the column looks like this. =CEILING(23456,100) =CEILING(45677,100) =CEILING(34567,100) When I put the fomula in the first line and then drag the corner of this cell down , it just copies the first line over the others and does not add the formula to each line. =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) Thanks Im sure this is basic. Im using XL 97 Regards -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add formula to a column of numbers
Bob Phillips wrote: Try =CEILING(A1,100) and copy down. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "steve" wrote in message oups.com... Basic question Im sure. I have a list of numbers 23456 45677 34567 etc. and I want to use this formula on them. =CEILING(#####,100) How can I easily add the format or formula (what ever it is called) to the whole list eg so the column looks like this. =CEILING(23456,100) =CEILING(45677,100) =CEILING(34567,100) When I put the fomula in the first line and then drag the corner of this cell down , it just copies the first line over the others and does not add the formula to each line. =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) Thanks Im sure this is basic. Im using XL 97 Regards This doesnt really work as it deletes the data in a1 if you put it in a1. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add formula to a column of numbers
Dave Peterson wrote: Say your data is in A1:Axxxx Then put your formula in B1 =ceiling(a1,100) and drag down that column. Excel will adjust that A1 reference to point at the cell in the same row. If you want you can hide Column A or you could select column B edit|copy edit|paste special|values and delete column A. steve wrote: Basic question Im sure. I have a list of numbers 23456 45677 34567 etc. and I want to use this formula on them. =CEILING(#####,100) How can I easily add the format or formula (what ever it is called) to the whole list eg so the column looks like this. =CEILING(23456,100) =CEILING(45677,100) =CEILING(34567,100) When I put the fomula in the first line and then drag the corner of this cell down , it just copies the first line over the others and does not add the formula to each line. =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) Thanks Im sure this is basic. Im using XL 97 Regards -- Dave Peterson This is a possible solution accept that it creates a second column, so that you must hide the first column. Regards |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add formula to a column of numbers
Or
and delete column A. steve wrote: Dave Peterson wrote: Say your data is in A1:Axxxx Then put your formula in B1 =ceiling(a1,100) and drag down that column. Excel will adjust that A1 reference to point at the cell in the same row. If you want you can hide Column A or you could select column B edit|copy edit|paste special|values and delete column A. steve wrote: Basic question Im sure. I have a list of numbers 23456 45677 34567 etc. and I want to use this formula on them. =CEILING(#####,100) How can I easily add the format or formula (what ever it is called) to the whole list eg so the column looks like this. =CEILING(23456,100) =CEILING(45677,100) =CEILING(34567,100) When I put the fomula in the first line and then drag the corner of this cell down , it just copies the first line over the others and does not add the formula to each line. =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) Thanks Im sure this is basic. Im using XL 97 Regards -- Dave Peterson This is a possible solution accept that it creates a second column, so that you must hide the first column. Regards -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Add formula to a column of numbers
You put it in B1. No formula can work in a cell as well as the value.
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "steve" wrote in message ups.com... Bob Phillips wrote: Try =CEILING(A1,100) and copy down. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "steve" wrote in message oups.com... Basic question Im sure. I have a list of numbers 23456 45677 34567 etc. and I want to use this formula on them. =CEILING(#####,100) How can I easily add the format or formula (what ever it is called) to the whole list eg so the column looks like this. =CEILING(23456,100) =CEILING(45677,100) =CEILING(34567,100) When I put the fomula in the first line and then drag the corner of this cell down , it just copies the first line over the others and does not add the formula to each line. =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) =CEILING(23456,100) Thanks Im sure this is basic. Im using XL 97 Regards This doesnt really work as it deletes the data in a1 if you put it in a1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| how write excel formula numbers in column => &=< between 20-40 | New Users to Excel | |||
| Formula for a column | Excel Discussion (Misc queries) | |||
Linear Mode
