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:
adelamad pe Simpatie.ro
 | Femeie
22 ani
Galati
cauta Barbat
28 - 45 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 795
|
|
This is a neat trick that not many people know about apparently.
For the text plus comment combination not even ChatGPT figured it out, I did. Eventually... after trying stuff out.
Here goes:
1. Add comment inside calculation formulas - the N() function
= 1234 + 4321 + N("description of the amounts can go in here")
The result will be 5555 because N("text") returns 0. But you will have a bonus comment if you select the cell containing the result of the sum.
Always use + or -, and never use * or : with N().
Adding (+) or subtracting (-) zero from a number will not change the result.
But multiplying (*) or dividing (:) by zero will either return 0 or a #DIV0! error, which you don't want.
For formulas that involve divisions or other more complex operations between numbers, you can always enclose them between parenthesis if normal +N("") fails, although it should not. This works fine:
= SUMIF(Table8[Unit];"kg";Table8[Quantity])/1000 +N("comment here")
2. Add comment for text displayed in a cell - the N() function combined with the T() function
N(123) will return 123 (the number), while N("Comment HERE") will return 0.
T(123) will return "", while T("Comment HERE") will return Comment HERE.
I have a cell with the name John and want to specify which John he is (because there are multiple Johns).
Any operator used in a formula with T() will return a #VALUE! error since you cannot sum text to a number.
So you cannot simply use = T("John") + N("John from accounting") as it will result in an error because it tries = John + 0
You have to get a bit creative:
= T("John") & T(N("John from accounting"))
Note that I used the & sign to concatenate, instead of an operator.
Always use & to concatenate, and never use an operator like + or - or * or : with T().
The trick above works, because:
T("John") displays John
N("John from accounting") displays 0
T(N("John from accounting") = T(0) and displays ""
= T("John") & T(N("John from accounting")) displays John & "" which is just John
More on the N() and T() functions:
|
|
| pus acum 3 saptamani |
|