Examples of using The value in cell in English and their translations into Slovenian
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Financial
-
Computer
-
Official/political
-
Programming
The value in cell C2.
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.".
Joins three things: the string in cell C2,a string with a comma and a space character, and the value in cell B2.
Determines if the value in cell A5 is not equal to"Sprockets.".
If the value in cell A5 is not equal to"Sprockets" or the value in A6 is not equal to"Widgets", return"OK.".
Divides the value in cell A1 by the value in A2.
If the value in cell A2 is not less than or equal to 15, return"OK.".
Subtracts the value in cell A2 from the value in A1.
If the value in cell A2 is not equal to 15, then return“OK”, otherwise return“Not OK”.
Multiplies the value in cell A1 times the value in A2.
Raises the value in cell A1 to the exponential value specified in A2.
Displays the value in cell A3 if it is greater than 1 AND less than 100, otherwise it displays a message.
Determines if the value in cell A5 is not equal to"Sprockets" or if the value in A6 is equal to"Widgets.".
For example, if the value in cell A2 is"156-" the following formula convertsthe text to the value- 156.
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.".
Displays the value in cell A3 if it is greater than 1 OR less than 100, otherwise it displays the message"The value is out of range".
Displays the value in cell A2 if it's less than A3 AND less than 100, otherwise it displays the message"The value is out of range".
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 A2 is greater than the value in A3 and also if the value in A2 is less than the value in A4.
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.".
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).
These numbers represent the values in cell A9 and B9 on the worksheet.
These numbers represent the values in cell A9 and B9 on the worksheet.
But the result of =A1/B1 depends on the values in cell A1 and B1.
That is, the values in cells D14:D15(the resources used) must be less than or equal to the values in cells F14:F15(the available resources).
What-if analysis changes the values in cells to see how those changes will affectthe outcome of formulas on the sheet.
What-if analysis changes the values in cells to see how those changes will affectthe outcome of formulas on the sheet.