# Excel - COLUMN Function Problem - Expert Solution

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

I need to multiple a column then round to the nearest 9 whole dollar while staying in a single column so i need to take the product then round it to the nearest 9
Solved by B. B. in 21 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 30/03/2018 - 04:13
HI
Excelchat Expert 30/03/2018 - 04:13
How are you doing
User 30/03/2018 - 04:13
Hello I am doing fine just racking my brain
Excelchat Expert 30/03/2018 - 04:14
ok so i see you problem
Excelchat Expert 30/03/2018 - 04:14
I need to multiple a column then round to the nearest 9 whole dollar while staying in a single column so i need to take the product then round it to the nearest 9
Excelchat Expert 30/03/2018 - 04:14
you say multiply a column with which number?
User 30/03/2018 - 04:15
787.95
User 30/03/2018 - 04:15
but the number will be different every time
User 30/03/2018 - 04:15
I am looking for a furmula to get that number multiplied by 2 then rounded to the nearest whole dollar 9
Excelchat Expert 30/03/2018 - 04:16
so bacically a number say X in this case 787.95 by 2
Excelchat Expert 30/03/2018 - 04:16
hen round to the nearest 9
User 30/03/2018 - 04:16
yes all in the same column
User 30/03/2018 - 04:16
compacted into one forumla
Excelchat Expert 30/03/2018 - 04:17
ok but 787.95 will be in different column ok
User 30/03/2018 - 04:17
that is fine
Excelchat Expert 30/03/2018 - 04:17
in this case
Excelchat Expert 30/03/2018 - 04:18
1575
Excelchat Expert 30/03/2018 - 04:18
787.95*2
Excelchat Expert 30/03/2018 - 04:18
=1575.9
Excelchat Expert 30/03/2018 - 04:18
closed number that is divisible by 9 is 1575
Excelchat Expert 30/03/2018 - 04:18
that right
Excelchat Expert 30/03/2018 - 04:19
hello is that right
User 30/03/2018 - 04:19
yes so the outcome should be 1579 instead of 1575
Excelchat Expert 30/03/2018 - 04:19
ohh ending always 9
User 30/03/2018 - 04:19
yes
Excelchat Expert 30/03/2018 - 04:19
that way
Excelchat Expert 30/03/2018 - 04:20
1571 is 1579 right?
User 30/03/2018 - 04:20
1579 is right
Excelchat Expert 30/03/2018 - 04:20
give me a min
User 30/03/2018 - 04:20
okay
User 30/03/2018 - 04:29
are you still there ?
Excelchat Expert 30/03/2018 - 04:29
yes few more min
User 30/03/2018 - 04:29
okay
Excelchat Expert 30/03/2018 - 04:32
can you see the formula in B!
Excelchat Expert 30/03/2018 - 04:32
b1
Excelchat Expert 30/03/2018 - 04:32
any number ending is 9
User 30/03/2018 - 04:32
does it work for 787 ?
Excelchat Expert 30/03/2018 - 04:33
see
Excelchat Expert 30/03/2018 - 04:33
User 30/03/2018 - 04:33
okay thank you
Excelchat Expert 30/03/2018 - 04:33
you can test few of you senarious
Excelchat Expert 30/03/2018 - 04:33
if you want to change the location
Excelchat Expert 30/03/2018 - 04:33
=(ROUNDUP(ROUNDDOWN(\$A\$1*2,0.01)/10,0.1)*10)-1
Excelchat Expert 30/03/2018 - 04:33
change A1 to any cell your working on
User 30/03/2018 - 04:34
what is the dollar signs for
Excelchat Expert 30/03/2018 - 04:34
absolute value
Excelchat Expert 30/03/2018 - 04:34
thats all
User 30/03/2018 - 04:34
okay i see the rest makes sense
Excelchat Expert 30/03/2018 - 04:34
:) is this what you needed
User 30/03/2018 - 04:34
yes it is
User 30/03/2018 - 04:34
thank you very much
Excelchat Expert 30/03/2018 - 04:34
Please click on end session and leave a feedback
User 30/03/2018 - 04:35
will do

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.