Question: The values for A2 and B2 are random integer variables from 1 to5. I need to write an if statement that gives value of5 if

The values for A2 and B2 are random integer variables from 1 to5.

I need to write an if statement that gives value of5 if the values of (A, B) are (5,5), (4,5), (5,4), (3,5),or (5,3) and gives a value of 3 if the values of(A,B) are (5,1), (4,2), (5,2), (2,3), (3,3), (4,3), (2,4), (3,4),(2,5) and gives a value of 1 if the (A, B) are(1,1) (2,1), (3,1), (4,1), (1, 2), (2,2), (2,3), (1,3), (1,4), and(1,5) ?

Please write down the function to calculate the cell value of C2?

Row 1ABC
Row 235


Step by Step Solution

3.47 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Answer The following function can be used to calculate the value of C2 based on th... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!