Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

EXCEL IF Conditional Statement I want to write an if statement in excel that Row 1 A B C Row 2 3 5 The values

EXCEL IF Conditional Statement

I want to write an if statement in excel that

Row 1 A B C
Row 2 3 5

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

I need to write an if statement that gives value of 5 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 ?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

2. What do you believe is at the root of the problem?

Answered: 1 week ago