Question

All formulas that begin with =IF will

A. change the formatting of a cell in a specific way if certain conditions are met.
B. return a specific value, calculation, or message if certain conditions are met.
C. always copy the contents of the adjecent cells if they contain data.
D. remove contents from a cell if they will likely cause an error during calculations.

Answer 1

return a specific value, calculation or message if certain condition met

Step-by-step explanation:

"if" is used for conditional statements that means, do some work if the condition is met against that logic.

e.g.

If (a > 5)

{

Show "a is greater than 5"

}

so if we put a= 6 than condition met and given statement will be shown on out put as "a is greater than 5".