Question
Date Amount Vendor SSS Group VenChange 1/10/2010 $137.74 3203 1 760 0 1/10/2010 $137.74 4589 2 760 1 1/10/2010 $137.74 6932 3 760 1 =IF(AND(G784>G783,F784
| Date | Amount | Vendor | SSS | Group | VenChange |
| 1/10/2010 | $137.74 | 3203 | 1 | 760 | 0 |
| 1/10/2010 | $137.74 | 4589 | 2 | 760 | 1 |
| 1/10/2010 | $137.74 | 6932 | 3 | 760 | 1 |
=IF(AND(G784>G783,F784<>F783),1,0)
A. Please explain as much as you can about this formula. Column G is the column for SSS, and F is the column for Vendor. Explain how this statement works, given the information for column F and G.
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
Analysing Financial Statements For Non-Specialists
Authors: Jim OHare
2nd Edition
1138641529, 9781138641525
