Hello,
I am trying to rank some of our competitors using their financial
ratios using 16 criteria to come to a total ranking for them. How do I
write a IF statement to give each one a ranking of one point for
meeting this criteria. For example
There current ratio must be at least 1 to 1 to get a point, if it is
less that 1 warn me it does not meet my criteria.
Then there are a few where they get one point for every half a percent
they are above the criteria.
A sample of some criteria
Net profit margin must exceed 5% to get a point
Total debt to total asset must be less than 150% or (1.5)
Earnings Yield must exceed 8% and for every half a % they get one
point
Hope this helps, and thanks for you help
Kind Regards
--
redlion
------------------------------------------------------------------------
redlion's Profile:
http://www.excelforum.com/member.php...o&userid=36140
View this thread:
http://www.excelforum.com/showthread...hreadid=559176