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
A1 is your number
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.
