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
yes please
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.