Question
Help with formulas please: In cell I11, calculate the total amount spent on groceries using a credit card. The result will be negative. In cell
Help with formulas please:
In cell I11, calculate the total amount spent on groceries using a credit card. The result will be negative.
In cell I12, calculate the average spent on groceries using a credit card. The result will be negative.
In cell I13, calculate the number of times groceries were purchased using a credit card during the month.
In cell F7, nest an AND function within an IF function to determine if the transaction was paid using a credit card and the amount of the transaction is less than -100.
If both conditions are met in the AND function, the function should return the text Flag. For all others, the function should return the text OK.
Copy the function down through cell F24.
? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW DEVELOPER 4 Position: Amount: Method of Payment Check Check Debit Card Check Transfer Check Check Credit Card Check Debit Card Check Transfer Credit Card Check Check Check Debit Card Debit Card Payee Category Amount Groceries Date 2017-06-01 Zachary Kaye 2017-06-04 Visa 2017-06-08 South & Main 2017-06-08 Income Total Cost: Average Cost: Occurrences: (259.32) (129.66) Rent Credit Card Payment ATM Withdrawal Salary Transfer to Savings Electric Bill 800 300 202 2034.78 Groceries - Credit Car Total Cost: Average Cost: Occurrences: 11 2017-06-08Savings Account] 12 2017-06-15 SEC 13 2017-06-15 Springfield Savings & LoansStudent Loan 14 2017-06-18 Gas-N-Wash 15 2017-06-18 SGW 16 2017-06-22 South & Main 17 2017-06-22 Income 18 2017-06-22 Savings Account] 19 2017-06-23 George's SuperMart 20 2017-06-25 CIV Solutions 21 2017-06-25 Springfield Savings & LoansCar Loan 22 2017-06-28 AMP Insurance 23 2017-06-29 Sam's Stop 24 2017-06-30 George's SuperMart 217.61 175 -65.33 43.59 262 2034.78 300 109.64 102.83 233 96.47 -60.08 149.68 Gas Water Bill ATM Withdrawal Salary Transfer to Savings Groceries Cable/Internet Average Credit Card Purchase: Total Remaining: Check Credit Card Debit Card Transfer Car Insurance Payment Options: Groceries | JuneTotals June2017 Annua|Exp|HomeLoan CarLoan Stocks + 100%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started