0
How can you keep a excel cell not to fall below a set number in a formula?
Wiki User
∙ 15y ago
You need to use the IF function. Something like:
=IF(C12*D12<100,100,C12*D12)
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
What are the functions of cells in Excel?
In effect a cell in Excel is a box where either text, number or formula can be placed.
The excel formula for raising a number in cell B1 to the power in cell C1 is?
=b1^c1
What is cell in Microsoft office excel?
A cell is a rectangle that can hold a number, text, formula etc.
Where Excel displays the formula that is in a cell IS WHAT?
The formula bar.
What is a number that can be entered into a cell on Excel?
Which of the following is a number that can be entered into a cell?
When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?
first
What do you have to put in a cell to denote an equation in Excel?
In Excel an equation can be a formula. All formulas in Excel must start with the equals sign. That is what tells Excel it is a formula.
In Excel what can be assigned to a cell that will display a calculated result?
formula
How do I add round to a formula in Excel to show no decimal places in Excel?
There is a function called ROUND which you can use to round to zero decimal places. If your number was in cell A2, the formula would be:=ROUND(A2,0)
What is Cell entry that performs a computation in excel?
A formula.
How does Excel recognize that you are entering a formula into a cell?
All formulas must begin with the equals sign. That is how Excel knows it is a formula.
What does a green arrow in the corner of an Excel cell mean?
A green arrow in the corner of an excel cell means that excel suspects soemthing may be wrong with the formula in a particular cell.
