• 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
4 answers
please help me
• 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"," ")
=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"," ")
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