Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel formula to copy/paste formula needed please. colwyn Excel Discussion (Misc queries) 4 October 22nd 08 11:27 PM
IF AND Formula Help Needed Karen Smith Excel Discussion (Misc queries) 8 December 17th 07 07:09 PM
Formula needed - is this possible? Kelly 1st Excel Discussion (Misc queries) 0 March 28th 07 01:00 AM
Formula Needed lsmith Excel Discussion (Misc queries) 1 June 8th 06 09:12 PM
Formula Needed... Steven Sinclair Excel Worksheet Functions 15 December 16th 05 02:41 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"