Excel - IF Function Problem - Expert Solution

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

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.