compute values in a range

Posts: n/a

try
=if(X1<.96,0,if(X1=1.07,2,if(X1<1,.25+.75*(X1-.96),1+1*(1.07-1))))

"Julie" wrote:

I am trying to compute a payout curve based on the following:

Amount Payout
96% 25%
100% 100%
107% 200%

With those three data points, how do I determine the payouts on all the % in
between what would a 96.1%, 96.2%, etc payout be?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
How to compute StDev of only nonzero entries in a range?	Sam	Excel Worksheet Functions	3	February 5th 09 01:27 AM
How many values appear more than once in a range?	Bruce Norris	Excel Worksheet Functions	12	April 5th 05 12:44 PM
Checking ALL values in a range	nospaminlich	Excel Discussion (Misc queries)	13	February 10th 05 09:29 AM
How to move Y-axis values when X range is -a to +b	[email protected]	Charts and Charting in Excel	4	January 31st 05 11:54 PM
Can you average data in 1 column based on a range of values in another?	kman24	Excel Worksheet Functions	2	November 17th 04 02:09 PM

All times are GMT +1. The time now is 06:03 PM.

Menu

About Us