Question
For all ratios except Leverage Ratios and Avg Collection period =IF(AND(C5>D5,C5>B5),Good,IF(OR(C5>D5,C5>B5),Ok,Bad)) B5 - Industry Ratios 2020 C5 - ABC's ratios 2020 D5 - ABC's ratios
For all ratios except Leverage Ratios and Avg Collection period
=IF(AND(C5>D5,C5>B5),"Good",IF(OR(C5>D5,C5>B5),"Ok","Bad"))
B5 - Industry Ratios 2020
C5 - ABC's ratios 2020
D5 - ABC's ratios 2019
For Leverage Ratios and Avg Collection Period
=IF(AND(C5 Using the above, I am not coming up with the same Good, Bad, & Ok's as you. Did I use the wrong formulas?
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
Cost Benefit Analysis Concepts And Practice
Authors: Anthony E. Boardman, David H. Greenberg, Aidan R. Vining, David L. Weimer
5th Edition
1108401295, 978-1108401296
