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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Dulci-k Profile
 | Femeie
22 ani
Giurgiu
cauta Barbat
22 - 45 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
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
|
|
| pus acum 5 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 17 ani
Postari: 2186
|
|
In case you want another option and the use of percentages in cells with text, I have the following very helpful source:
The formula I made for something looking like this:
58,00% implemented actions
was:
=TEXT(ROUNDUP(C2/B2;3);"0,00%")&" implemented actions"
_______________________________________
|
|
| pus acum 4 ani |
|