Examples of using The value in cell in English and their translations into Hungarian
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Financial
-
Programming
-
Official/political
-
Computer
Displays the value in cell B6(4) 4.
Subtracts the value in cell A2 from the value in A1.
Returns the cotangent of the value in cell A5, 45(0.617).
If the value in cell A2 is not equal to 15, return"OK.".
If the value in cell A5 is not equal to"SPROCKETS", return"OK.".
If the value in cell A2 is not equal to 15, then return“OK”, otherwise return“Not OK”.
This formula looks for the value in cell B9 in the range B2:B22.
If the value in cell A2 is not less than or equal to 15, return"OK.".
Xls that gets the value in cell A1 of Book2. xls.
If the value in cell A5 is not equal to"Sprockets" or the value in A6 is not equal to"Widgets", return"OK.".
Because non-numeric values in references are not translated- the value in cell A5('5) and the value in cell A6(TRUE) are both treated as text-the values in those cells are ignored.
If the value in cell A2 is not equal to A3 and the value in A2 is also not equal to the value in A4, return"OK.".
Checks whether the value in cell A3, Region1, is text.
If the value in cell A2 is not equal to the value in A3 or the value in A2 is not equal to the value in A4, return"OK.".
Determines if the value in cell A5 is not equal to"Sprockets.".
If the value in cell A2 is greater than the value in A3 and the value in A2 is also less than the value in A4, return"OK.".
Divides the value in cell A1 by the value in A2.
Which says IF(the value in cell F2 equals 1, then return the value in cell D2, IF the value in cell F2 equals 2, then return the value in cell D3, and so on, finally ending with the value in cell D8 if none of the other conditions are met).
Multiplies the value in cell A1 times the value in A2.
For example, if the value in cell is"100", then you apply cell formatting to this cell and change the"100" into"$100.00 USD", so the shown value in cell is"$100.00 USD".
Subtracts the value in cell A2 from the value in A1.
Determines if the value in cell A5 is not equal to"Sprockets" or if the value in A6 is equal to"Widgets.".
Determines if the value in cell A2 is greater than the value in A3 and also if the value in A2 is less than the value in A4.
But the result of =A1/B1 depends on the values in cell A1 and B1.
Adds the values in cells A5 and A6, and then adds 2 to that result.
Adds the values in cells A2 through A4, and then adds 15 to that result.
For example, the formulas=SUM(A1:A2) and SUM(A1,A2)both use the SUM function to add the values in cells A1 and A2.