If cell A1 has value 10 and cell B1 has value 11, what is the formula in cell C1 to calculate subtraction of value in A1 from value in A2?
Answers
Explanation:
formula in cell C1 to calculate subtraction of value in A1 from
Answer:
Assume that the missing part should be "not listed". In such a situation, you need to use the IF function along with AND to test the values in A1 and B1. If both criteria are met, subtract A1 from A2. Otherwise, return "not specified".
=IF(A(A1=10,B1=11);A2-A1,"not entered")
Explanation:
Cells are the fields you see in an Excel worksheet grid like this one. Each cell is identified on the sheet by its reference, column letter, and row number, which intersect at the cell location. This cell is in column D and row 5, so it is cell D5. The column always comes first in the cell reference.
Assume that the missing part should be "not listed". In such a situation, you need to use the IF function along with AND to test the values in A1 and B1. If both criteria are met, subtract A1 from A2. Otherwise, return "not specified".
=IF(A(A1=10,B1=11);A2-A1,"not entered")
Each cell has its own set of coordinates or position in the sheet, such as A1, A2, or M16. In the example above, we are positioned at cell A1, which is the intersection of column A and row 1.
You can store data in a cell, such as a formula, a text value, a numeric value, or a date value.
You can do many things with cells in Excel, such as changing the font format, number format, background, alignment, and conditional formatting.
brainly.in/question/24824469
#SPJ3