• Bill wants the entry in Column G to remind him of expenses that require receipts for the accountant. Tell Bill what to put in Column G to do this:

a. Print the word “Yes” in any row where the total daily expenses are greater than or equal to $100.00.
b. If the daily expenses total is less than $100.00, leave the Column G entry for that row blank.

I am having a lot of trouble with this problem

• What formula or function does he put in Column F that will show the total expenses for each day?

=SUM(B8,C8,D8,E8)
• What formula or function does he put in columns B through F in Row 13 that will give him the total expenses for the week in each category?
=SUM(B13,C13,D13,E13)
• Bill wants the entry in Column G to remind him of expenses that require receipts for the accountant. Tell Bill what to put in Column G to do this:
a. Print the word “Yes” in any row where the total daily expenses are greater than or equal to $100.00.
=IF(F9>100,"YES"," ")
=IF(F12>100,"YES"," ")

please help me

OMG, Who are you that made me so happy with your assistance. Thank you wherever you are. God blesses you. I have been trying to decipher this excel formula for hours. Thank you.

I tried that formula and keep telling me error

To solve this problem, you need to use a formula in Column G that checks if the total daily expenses are greater than or equal to $100.00. Here's how you can do it:

1. Click on the first cell in Column G where you want the entry to be (for example, G2).
2. To check if the total daily expenses in that row are greater than or equal to $100.00, you can use the following formula:
=IF(SUM(A2:F2) >= 100, "Yes", "")

Let's break down this formula:
- SUM(A2:F2) calculates the sum of the values in cells A2 to F2, which represent the daily expenses in that row.
- >= 100 checks if the sum is greater than or equal to $100.00.
- "Yes" is the text that will be displayed in Column G if the condition is met.
- "" (two double quotes with nothing in between) specifies that the cell should be left blank if the condition is not met.

3. Press Enter to apply the formula to the first cell in Column G (G2).
4. The "Yes" text will appear in Column G for rows where the total daily expenses are greater than or equal to $100.00. For rows with daily expenses below $100.00, the entry in Column G will be left blank.

5. Now, simply copy the formula from G2 to the rest of the cells in Column G, if needed. To do this, click on the cell that contains the formula (G2), place your cursor over the bottom-right corner of the cell (it should turn into a bold plus sign), then click and drag the formula down to copy it to the desired cells.

By following these steps, you should be able to populate Column G with the appropriate entries based on the total daily expenses.