Suppose that cell B2 contains the budgeted amount and cell C2 contains the actual amount. Write the formula (including the IF conditions) that would insert the word under if the actual amount was less than the budgeted amount and insert the word over if the actual amount was greater than the budgeted amount.

Question

Suppose that cell B2 contains the budgeted amount and cell C2 contains the actual amount. Write the formula (including the IF conditions) that would insert the word under if the actual amount was less than the budgeted amount and insert the word over if the actual amount was greater than the budgeted amount.

Answer 1

http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=excel+tutorials

Answer 2

To achieve this, you can use the IF function in Excel. The IF function allows you to perform different actions based on a specified condition. Here's the formula you can use:

```excel
=IF(C2 < B2, "Under", IF(C2 > B2, "Over", "Equal"))
```

Let's break down the formula:

1. `C2 < B2` checks if the actual amount is less than the budgeted amount.
2. If the condition is true, "Under" will be inserted.
3. If the condition is false, the formula moves to the next IF condition.
4. `C2 > B2` checks if the actual amount is greater than the budgeted amount.
5. If the condition is true, "Over" will be inserted.
6. If the condition is false, meaning the actual amount equals the budgeted amount, the formula will return "Equal".

You can modify the text inside the quotes ("Under", "Over", "Equal") based on your requirement.

Remember to adjust the cell references (B2, C2) in the formula based on where your budgeted and actual amounts are located in your specific spreadsheet.