Hello fellow members,
I appreciate you taking the time to view this post, and hope that I can fully explain the challenge that I need assistance with.
I am working on a project that we are working with our customers to no longer pay with cash, and have given the option to pay with check, credit card or eCheck.
My spreadsheet columns include Account Number(A), Account Name (B), Payment Date (C), Payment Type (D, this refers to Cash, Check, Credit Card, eCheck), Receipt Number (E, Check # if check), Payment Amount (F). Columns G-J include Cash, Check, Credit Card, eCheck. I have written an IF statement in these columns to count the times when the customer has paid by cash, check, credit card or eCheck. Next, I performed a Subtotal for all payment types.
My challenge is that I need to create an IF statement that will identify any customer that has paid with non-cash (check, credit card, eCheck) on the last 3 consecutive deliveries.
What is the best function to achieve the desired result? Thanks again.
I appreciate you taking the time to view this post, and hope that I can fully explain the challenge that I need assistance with.
I am working on a project that we are working with our customers to no longer pay with cash, and have given the option to pay with check, credit card or eCheck.
My spreadsheet columns include Account Number(A), Account Name (B), Payment Date (C), Payment Type (D, this refers to Cash, Check, Credit Card, eCheck), Receipt Number (E, Check # if check), Payment Amount (F). Columns G-J include Cash, Check, Credit Card, eCheck. I have written an IF statement in these columns to count the times when the customer has paid by cash, check, credit card or eCheck. Next, I performed a Subtotal for all payment types.
My challenge is that I need to create an IF statement that will identify any customer that has paid with non-cash (check, credit card, eCheck) on the last 3 consecutive deliveries.
What is the best function to achieve the desired result? Thanks again.