Question

Suppose cell B2 in a spreadsheet contains the formula: =if(A1>100,'bazinga','zippo") If cell A1 contains the value 425, what value appears in cell B2?

Answer 1

Answer:

bazinga

Explanation:

The 'IF' function is a conditional function in excel which states a condition that gives a particular value if true or another value if false.

Here, The condition is if the value in cell A1 is greater than 100(true) , then cell B2 should show 'bazinga'. If the value is below 100(false), then cell B2 will show 'zippo'. In this case, value in A1 is 425 which is more than 100, so the condition is true and cell 2 will show 'bazinga'.