**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.*