0
What function do you use to fill a selected cell with y if cell L8 is greater than 10 and n if cell L8 is less than or equal to 10?
Wiki User
∙ 10y ago
You use the "IF" function.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is the command that formats the selected cell as a percentage rounded to the nearest hundredth?
comma style
8 A command that formats the selected cell as a percentage rounded to the nearest hundredth is the Style?
percent style
What function would you use to change the appearance of data in a cell from decimal to percentage?
I would use the Format options, not a function.
Which function would you use to change the appearance of data in a cell from decimal to percentage?
format
What is the formula if price drops in 30 percent in excel?
If you put the original price in cell A1, then the formula you insert into cell B1 or whichever other cell you wish to calculate the new value is: =A1*(1-(30/100))
How do you use the worksheet function to fill the selected cell with Y if cell B4 is greater than cell B3 and N if cell B4 is less than cell B3?
Note that your question does not specify what happens if B4 is equal to B3, so the following assumes it is left blank: =IF(B4>B3,"Y",IF(B4<B3,"N","")) If Y is for greater or equal to: =IF(B4>=B3,"Y","N") If it is N for equal to and Y is only for greater than: =IF(B4>B3,"Y","N")
What function retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell?
NOW function
Is it true If each cell in a selected range is next to a row of numbers Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked?
false
Retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell?
NOW function
The MAX function determines the value in a selected range of values?
It determines the cell entry with the greatest value.
What is the if function for cell c3 that assigns the value of cell d5 to cell c3 if the value in cell f2 is greater than the value in cell f3 otherwise the if function assigns 0 to cell c3?
=IF(F2>F3,D5,0)
What is the comparison operator used for not equal to in Excel?
You can use the Not function or the <> operator, which is the < and the > beside each other. To see if the values in A1 and A2 are not equal to each other, you can type: =A1<>A2 or =Not(A1=A2) In each case they will either give you TRUE if they are not equal or FALSE if they are equal, in the cell that you enter the formula into.
What is the black line around an active cell?
It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.It is a cell border to indicate that the cell is the active cell when it is the only cell selected. When multiple cells are selected, there is still only one active cell, but the border is around that area of cells. If multiple ranges are selected, then no border appears around the active cell or the any of the selected areas.
How do you specify in the selected range whose cell value is greater than 2000 will automatically be formatted in italics?
conditional formating
What is a cell called when it is selected?
You can have more than one cell selected at once. When that happens one cell is known as the active cell, which is also the case if there is only one cell selected. If you start typing, it is the cell into which data will go. There are no special names for the other cells that may also be selected at that time, so the answer you are looking for is the active cell.
Does the number of chromatin in a cell vary depending on the function of the cell?
All cells in a body have equal number of chromatins(hence chromosomes).
What is a selected cell?
The active cell that you have clicked on.
