R
redlion
Hello,
I am trying to rank some of our competitors using their financia
ratios using 16 criteria to come to a total ranking for them. How do
write a IF statement to give each one a ranking of one point fo
meeting this criteria. For example
There current ratio must be at least 1 to 1 to get a point, if it i
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 percen
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 on
point
Hope this helps, and thanks for you help
Kind Regard
I am trying to rank some of our competitors using their financia
ratios using 16 criteria to come to a total ranking for them. How do
write a IF statement to give each one a ranking of one point fo
meeting this criteria. For example
There current ratio must be at least 1 to 1 to get a point, if it i
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 percen
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 on
point
Hope this helps, and thanks for you help
Kind Regard