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.