answersLogoWhite

0


Best Answer

You use the "IF" function.

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: 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?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

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


The MAX function determines the value in a selected range of values?

It determines the cell entry with the greatest value.


Retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cell?

NOW function


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.