Question

a. Write an if statement that puts 1 in the current cell of a spreadsheet if the floating-point values in cells B2 and B3 are equal and otherwise puts 0 in the current cell.

b. In another computational tool, write an if statement that displays 1 if 34. a. the floating point values in x and z are equal and otherwise displays 0.

Answer 1

The syntax for the IF function is:

=if ( test, then_true, otherwise_value )

The function's three arguments are:

• test - (required) a value or expression that is tested to see if it is true or false;
• then_true - (required) the operation that is carried out if the test is true;
• otherwise_value - (optional) the operation that is carried out if the test is false.

Note: When entering the IF function, the three arguments are separated by commas ( , ).

So i giving your questions answer

(a) = if(B2=B3,1,0)

B2=B3,when true put 1 in cell otherwise 0.

(b) in other computational tool that is c++, the if statement is

if(float x==float z)

{

cout<<1;

}

else

cout<<0;

if any dificulty,you can commenton this,otherwise upvote me.