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?

Question

Social Studies

Yair Huynh

2 October, 08:13

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?

+3

Answers (1)

Know the Answer?

Averi Haley · Answer 1

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'.