Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
iulia2006 pe Simpatie
 | Femeie
24 ani
Bucuresti
cauta Barbat
25 - 49 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
Let's assume you want to calculate something in a cell and the obtained result contains decimals.
You want to also add text in that cell, not the adjacent one.
If you write your formula like this:
=A1/A2&" kilograms"
A1 = 1000, A2 = 85
The result will be displayed as: 11,7647058823529 kilograms
But you don't want that many decimals for your number, just 2.
Using the ROUNDUP function you limit those decimals to just 2 and add text after them. Formula will look like:
=ROUNDUP(A1/A2;2)&" kilograms"
where the second argument from ROUNDUP function (2) is the number of decimals you want to have.
The result will be displayed as: 11,77 kilograms
|
|
| |
|
| #2 |
|
|
In case you want another option and the use of percentages in cells with text, I have the following very helpful source:
https://www.benlcollins.com/formula-exa ... t-numbers/
The formula I made for something looking like this:
58,00% implemented actions
was:
=TEXT(ROUNDUP(C2/B2;3);"0,00%")&" implemented actions"
_______________________________________
|
|
| |
|
