**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to multiply a number by two then take the product and round to the nearest whole dollar 9 all in one cell if possible

Solved by M. E. in 7 mins

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

Excelchat Expert
30/03/2018 - 03:54

Hi

User
30/03/2018 - 03:54

hello

Excelchat Expert
30/03/2018 - 03:54

welcome to got it pro

Excelchat Expert
30/03/2018 - 03:54

do you have some sample data that you can paste here?

User
30/03/2018 - 03:54

sure

User
30/03/2018 - 03:55

what i have been working with

Excelchat Expert
30/03/2018 - 03:55

which columns you need to multiply

Excelchat Expert
30/03/2018 - 03:56

are you there?

User
30/03/2018 - 03:56

i would like to multiple column b mutiple by two then round to the nearest 9 i have it done just in 3 different coluns i would like it to be compressed into one formula

Excelchat Expert
30/03/2018 - 03:58

have a look at column F

Excelchat Expert
30/03/2018 - 03:58

that should help you out

User
30/03/2018 - 03:58

could you explain or too much information ?

Excelchat Expert
30/03/2018 - 03:59

there are two parts to the formula

Excelchat Expert
30/03/2018 - 03:59

first we are dividing the number by 10 and taking integer and then multiplying by 10

Excelchat Expert
30/03/2018 - 03:59

so we will get 1570

Excelchat Expert
30/03/2018 - 03:59

in second part we are taking mod

Excelchat Expert
30/03/2018 - 03:59

which will give remainder when divided by 10

Excelchat Expert
30/03/2018 - 04:00

so if remainder is greater than 5 it is taking 9 as it is nearest

Excelchat Expert
30/03/2018 - 04:00

otherwise -1

Excelchat Expert
30/03/2018 - 04:00

have a look at the formula

Excelchat Expert
30/03/2018 - 04:00

it should help you in understanding

User
30/03/2018 - 04:00

i am looking at it i believe i understand

User
30/03/2018 - 04:00

thank you for you help today

Excelchat Expert
30/03/2018 - 04:00

welcome

Excelchat Expert
30/03/2018 - 04:01

please do give good rating

Excelchat Expert
30/03/2018 - 04:01

it really helps

User
30/03/2018 - 04:01

okay will do

Excelchat Expert
30/03/2018 - 04:01

thanks

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