The expression - IF(A1 > 12, 6A1, 2A1) is used in a spreadsheet. Find the result...

Question

Question

math algebra

Answer 1

Answer #1

The expression can be written in layman's terms as follows

If the value of A1 is more than 12, then the value of the result will be 6*A1

If the value of A1 is not more than 12, then the value of the result will be 2*A1

Case 1:
A1=7

The value of A1, as we can see, is not more than 12

Hence, the value of the result will be 2*A1 , that is 2*7=14

Case 2:

A1=13

The value of A1, as we can see, is more than 12

Hence, the value of the result will be 6*A1=6*13=78

Answer 2

Similar Homework Help Questions

18. [-12 Points] DETAILS 0/6 Submissions Used Find the indicated set if given the following. A...

18. [-12 Points] DETAILS 0/6 Submissions Used Find the indicated set if given the following. A = {x|* 2 -4} B = {x|x <6) C = {xl -1 < x 57} (a) BUC O {xl x < 7) • {xx57) {x|6<x< 7) O {xl 6 SX57) all real numbers none of these (b) BAC {xl-4 < x <6) {x\-4 SX 56) {x{-1<x<6) {x-1556) all real numbers ООО none of these Mand Helm Type here to search O RI 99 a
Find all real solutions of the equation (2 – 6)? = 4. 21 = and 12...

Find all real solutions of the equation (2 – 6)? = 4. 21 = and 12 with i < 22
28. Show that there are 12 pairs of numbers (a1,az) with 0<aj < 4,0 <a2 <6...

28. Show that there are 12 pairs of numbers (a1,az) with 0<aj < 4,0 <a2 <6 so that x=a1 (mod 4) x = 22 (mod 6) has a solution.

12) Let U ={NEN:n <200} , find the number of elements of U that are divisible...

12) Let U ={NEN:n <200} , find the number of elements of U that are divisible by 2, 3, or 7.
12) Let f(A) = x + 1 xxo 0 x=0 (ax+ 2 x>0 a) Find lim...

12) Let f(A) = x + 1 xxo 0 x=0 (ax+ 2 x>0 a) Find lim f(x). X-70 b) Find lim F(x). X70 c) Find lim f(x). 13) Let f(x) = x - x .O 12.1 x 0 a) Find lim f(x). 6) Find
Write each expression as an algebraic (nontrigonometric) expression in u, u>0. sin 2 sec 9) 2...

Write each expression as an algebraic (nontrigonometric) expression in u, u>0. sin 2 sec 9) 2 sin 2 sec 2 (Simplify your answer.)

Use the given conditions to find the exact value of the expression. cos a = 24sin...

Use the given conditions to find the exact value of the expression. cos a = 24sin a < o, cos(a + 5) Need Help? ilk to a Tutor
(1 point) The set >-{[12][13) 45 is a basis for R2. Find the coordinates of the...

(1 point) The set >-{[12][13) 45 is a basis for R2. Find the coordinates of the vector i [13] relative to the basis B. []B =
3. Consider the following BNF for arithmetic expressions: <expression> ::= <term> <term>+ <expression> | <term> -...

3. Consider the following BNF for arithmetic expressions: <expression> ::= <term> <term>+ <expression> | <term> - <expression> <term> ::= <factor> | <factor> * <term> | <factor> I <term> <factor> ::= <constant> (<expression>) <constant ::= 0|1|2|3|4|5|6789 a) Show the expression tree of the following expression: 8/7*5/6-6/4/2-7*(5+2). b) Give the value of this expression. c) Same question as (a), if the BNF were <expression> ::= <term> | <expression>+ <term> | <expression> - <term> <term> ::= <factor> | <term>*<factor> | <term> / <factor>...

2. Find a general solution of X' = AX if 3 -1 (1A A1 = 12...

2. Find a general solution of X' = AX if 3 -1 (1A A1 = 12 = 2 1 [ 1] 3 -1 (2) A= 1 Xi = 1; 12 = 13 = 2 1 (3) A = 1 Xi = 0; 12 = 13 = 5 1 (4) A= 5 -4 0 0 2 0 2 5 0 0 0 3 1 0-1 1 1 0 0 2 2 - 1 0 1 0 11 = 1; 12 =...

The expression - IF(A1 > 12, 6*A1, 2*A1) is used in a spreadsheet. Find the result...