Jump to content

Macro or Formula help in Excel


CQI13

Recommended Posts

Can't think of anywhere else to ask this, and I know we have some knowledgeable users here, so...

 

I'm trying to run the QB Rating Formula in Excel for a project. Because I get confused over all the different arguments, I've created separate cells for each of the criteria, with the final formula at the end. It calculates everything fine, except for outliers, since each argument must be between 0 and 2.375.

 

For further clarification, here's the formula:

 

http://www.primecomputing.com/formula.htm

 

How would I set those limits in excel (for the results of each of the arguments to be between 0 and 2.375)?

 

Thanks in advance for any help.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...