Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

hi I need an entire column of annual salaries to monly salaries on excel.
Solved by G. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/08/2018 - 06:01
Welcome to ExcelChat!
Excelchat Expert 23/08/2018 - 06:02
You want to convert the column of annual salaries to the monthly salaries, right?
User 23/08/2018 - 06:02
Excelchat Expert 23/08/2018 - 06:02
Will you provide the data where you need the solution?
User 23/08/2018 - 06:03
I can give a sample if required
Excelchat Expert 23/08/2018 - 06:03
Yes please, I believe it will be easier for you to implement to the whole file if solution will be based on your sample
User 23/08/2018 - 06:04
that might take little time
User 23/08/2018 - 06:05
if you share a shortcut that will be great
User 23/08/2018 - 06:05
I have annual salaries and I need to convert it to month...an entire column
Excelchat Expert 23/08/2018 - 06:05
Do you want the final result to appear in the same column?
Excelchat Expert 23/08/2018 - 06:05
Just to replace it with monthly?
User 23/08/2018 - 06:06
no..right next to it
Excelchat Expert 23/08/2018 - 06:06
Okay
User 23/08/2018 - 06:06
annual on one column and monthly on the next column
Excelchat Expert 23/08/2018 - 06:07
Here is the formula for this case
Excelchat Expert 23/08/2018 - 06:08
=if(A2="","",A2/12)
Excelchat Expert 23/08/2018 - 06:08
We check if there is a number in the annual salary column. If no, we write nothing, if yes, we write the monthly salar
User 23/08/2018 - 06:09
do I have to use these formulaes?any shortcuts?
Excelchat Expert 23/08/2018 - 06:09
If you want to have the result in the next column, yes, you will have to put this formula
User 23/08/2018 - 06:10
ok thank you so much
Excelchat Expert 23/08/2018 - 06:10
you are welcome
Excelchat Expert 23/08/2018 - 06:10
When you put the formula in B2 (for example)
Excelchat Expert 23/08/2018 - 06:10
Then simply extend it down the column
Excelchat Expert 23/08/2018 - 06:10
As you can see, the whole column B is with the formula
Excelchat Expert 23/08/2018 - 06:10
But it shows the result only if there is a value in column A
User 23/08/2018 - 06:10
oh great
User 23/08/2018 - 06:11
I will try this shortly
Excelchat Expert 23/08/2018 - 06:11
To save the file, please press File -> Download as -> xlsx
User 23/08/2018 - 06:11
ok thanks again
Excelchat Expert 23/08/2018 - 06:11
You are welcome
Excelchat Expert 23/08/2018 - 06:11
Wish you a great day!
User 23/08/2018 - 06:11
thank u..you too

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.