Question

How do i enter this as a formula into excel IF function?




In cell C15, enter a formula using an IF function to determine if you need a loan. Your available cash is located on the Data sheet in cell A3 ($9000). If the price of the car is less than or equal to your available cash, display "no". If the price of the car is more than your available, cash, display "yes". Use absolute references where appropriate—you will be copying this formula across the row. The available cash is 9000




What would I enter into the Logical_test section?

Answer 1

Answer:

Call microsoft

Explanation:

Exel Is My Worst Nightmare Just Call Microsoft "I'd Hope They'd Have A Answer For That"

Answer 2

The IF function allows the user to make logical comparison among values.

The formula to enter in cell 15 is: $\mathbf{=IF(\ A\ 4 > \ A\ 3, "yes", "no")}$

The syntax of an Excel IF function is:

$\mathbf{=IF (logical\_test, [value\_if\_true], [value\_if\_false])}$

Where:

• IF $\to$ represents the IF function itself
• logical_test $\to$ represents values to be compared
• [value_if_true] $\to$ represents the return value if the condition is true
• [value_if_false] $\to$ represents the return value if the condition is false

From the question, the cells to compare are:

• Cell A3
• The cell that contains the car price (assume the cell is A4)

So, the IF function that compares both cells is:

$\mathbf{=IF(A4 > A3, "yes", "no")}$

The above formula checks if A4 is greater than A3.

• If the condition is true, the result is "yes"
• Otherwise, it is "no"

The question requires that the cells are referenced using absolute cell referencing.

This means that, we make use of the dollar sign ($), when writing the cells.

So, the correct formula is:

$\mathbf{=IF(\ A\ 4 > \ A\ 3, "yes", "no")}$

Read more about Excel formulas at:

https://brainly.com/question/1285762