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.