Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statements
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if statements, and statements | Excel Worksheet Functions | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Better Way to Code IF Statements? | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |