Cant find a way to calculate a percentage of only one specific cell into another cell. Im looking for a simple formula that take the value of a specific cell and multiply with for example 0.5 and then round it of.
Cant find a way to calculate a percentage of only one specific cell into another cell. Im looking for a simple formula that take the value of a specific cell and multiply with for example 0.5 and then round it of.
Last edited by Eazio; 08-02-2016 at 05:08 AM.
Like this, perhaps?
=ROUND((A1*0.5),0)
where A1 contains the original value.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Get an Excel Error every time I try to do that. It seems to refer to the 0.5. It somehow aint a valid formula.
The formula is perfectly valid and works perfectly here. See it working below in D1. What sort of data do you have in A1? It needs to be a number.
Round Formula.png
Last edited by AliGW; 08-02-2016 at 05:27 AM.
Well, In my case its the M122 and its 60 kg, I tried remove the prefix at the end but it didnt solved the problem.
Hmm, It still wont work. To be more specific the Excel Error want me to choose a formula from one of their lists. I shouldnt have to change anything right? Just copypaste and enter?
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
By the way, you might need to change commas to semi-colons for your locale - have you done that?
=ROUND((A1*0.5);0)
=ROUND(LEFT(A1,2)*0.5;0)
You will also need the Swedish names for the functions being used (ROUND and LEFT).
Forgott to change to the swedish equivalents and thought that would solve it all, nope. >< Tried both with and without the semi-colons.
Last edited by Eazio; 08-02-2016 at 07:28 AM.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Not quiet sure how to put this but here is a try.
Try this:
=ROUND(SUBSTITUTE(C5," kg","")*0.5,0)&" kg"
or in your case:
=ROUND(SUBSTITUTE(C5;" kg";"")*0.5;0)&" kg"
Last edited by AliGW; 08-02-2016 at 07:51 AM.
Think It finally worked!
Thanks alot :D
Great! Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks