Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Needed!
Hi, i have a problem regarding formulas in excel. The problem i am solving is
whether to grant a loan to an individual and it is determined through a point system. I have to set up a system in excel where points will be allocated to the individual when he or she meets a particular criteria (eg. age25, add 1 point). what formula should i use for the criteria: 2 points are deducted for each ADDITIONAL $10,000 of the requested loan? I know how to set basic criteria like (eg age25, add 1 point) using IF function : =IF(A225,"+1"). What i dont know is how i set a formula when the criteria is for every ADDITIONAL value (ie it will be never ending)? I hope i illustrated my problem clearly. Help would be very much appreciated! Cheers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
IF AND Formula Help Needed | Excel Discussion (Misc queries) | |||
Formula needed - is this possible? | Excel Discussion (Misc queries) | |||
Formula Needed | Excel Discussion (Misc queries) | |||
Formula Needed... | Excel Worksheet Functions |