< Go Back

Excel - COLUMN Function Problem - Expert Solution

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

I have a row of numbers in column B. I want to divide all those numbers by 2.2 in column C. Please help - I am 78 and have forgotten how to do it!

Solved by G. L. in 59 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert 06/08/2018 - 03:07
Hello
Excelchat Expert 06/08/2018 - 03:07
How are you today?
Excelchat Expert 06/08/2018 - 03:10
Please respond so that I can assist.
User 06/08/2018 - 03:15
I am fine, thanks. Sorry I could not get my computer to type in answers to above questions.
Excelchat Expert 06/08/2018 - 03:15
No problem
Excelchat Expert 06/08/2018 - 03:16
Can you see the preview on the right?
Excelchat Expert 06/08/2018 - 03:18
This is the formula you have to use
Excelchat Expert 06/08/2018 - 03:18
=B2/2.2
Excelchat Expert 06/08/2018 - 03:19
where b2 is the cell
Excelchat Expert 06/08/2018 - 03:19
then copy is down and this formula will copy
Excelchat Expert 06/08/2018 - 03:19
Thank you and have ag reat day
Excelchat Expert 06/08/2018 - 03:26
I am still here if you need some help
Excelchat Expert 06/08/2018 - 03:41
I hope I have answered your query to your satisfaction.
Excelchat Expert 06/08/2018 - 03:41
Please do provide good review after ending this session.
User 06/08/2018 - 03:41
I tried your suggestion and it
Excelchat Expert 06/08/2018 - 03:42
Ok
Excelchat Expert 06/08/2018 - 03:42
is it working at your end?
Excelchat Expert 06/08/2018 - 03:45
Please respond so that I can assist you.
User 06/08/2018 - 03:46
I tried the formula on column E and it did not work
Excelchat Expert 06/08/2018 - 03:47
Ok. Please tell me which cell you want to divide and show result on Column E
Excelchat Expert 06/08/2018 - 03:48
Please check. I copied the formula from Cell C2 to E2
Excelchat Expert 06/08/2018 - 03:48
In cell C2 formula is =B2/2.2
Excelchat Expert 06/08/2018 - 03:48
When I copied it in E2 it becomes =D2/2.2
Excelchat Expert 06/08/2018 - 03:49
Please check
User 06/08/2018 - 03:49
I wanted to divide all numbers in column B by 2.2 to replicate what you did
Excelchat Expert 06/08/2018 - 03:49
this formula is simple
Excelchat Expert 06/08/2018 - 03:50
Please go to cell C2
Excelchat Expert 06/08/2018 - 03:50
I deleted the formula
Excelchat Expert 06/08/2018 - 03:50
now you enter the formula for the first division
Excelchat Expert 06/08/2018 - 03:50
=B2/2.2
Excelchat Expert 06/08/2018 - 03:51
Try this.
Excelchat Expert 06/08/2018 - 03:52
Please go ahead and insert this formula and try if this is working.
Excelchat Expert 06/08/2018 - 03:52
we just have 15 minutes left. We will not be able to extend the session any more.

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 privacy is guaranteed. Your session will not be used for blog unless you give us persmission.