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.