software

Hello,
I need to display percentiles based on vlues I input, but I am limited
to 7 nested IF statements. Could somebody show me a way to do this
which will allow me to display the percentiles from 99% to 1%? Here is
what I have right now:

=IF(F3lt;6.68,quot;99quot;%,IF(F3lt;7.09,quot;98quot;%,IF(F3lt;7.72,quot;97quot; %,IF(F3lt;7.77,quot;96quot;%,IF(F3lt;8.1,quot;95quot;%,IF(F3lt;8.44,quot;94quot; %,IF(F3lt;8.96,quot;93quot;%,IF(F3lt;9.14,J3))))))))

thanks,
Mike--
Michael L
------------------------------------------------------------------------
Michael L's Profile: www.excelforum.com/member.php...oamp;userid=27787
View this thread: www.excelforum.com/showthread...hreadid=538996You can do building a two column list and using VLOOKUP. Following your
formula, you can create a list like this:
[Col A] [Col B]
0 99%
6.68 98%
7.09 97%
7.72 96%
7.77 95%
8.1 94%
....

And then, with the value you want to look at in cell C2, for example, you
can use this formula:
=VLOOKUP(C2,$A2:$B100,2)
The formula will look for the number closer to C2 in column A that is lower
than C2, and return the value on the column B.

Hope this helps,
Miguel.

quot;Michael Lquot; wrote:

gt;
gt; Hello,
gt; I need to display percentiles based on vlues I input, but I am limited
gt; to 7 nested IF statements. Could somebody show me a way to do this
gt; which will allow me to display the percentiles from 99% to 1%? Here is
gt; what I have right now:
gt;
gt; =IF(F3lt;6.68,quot;99quot;%,IF(F3lt;7.09,quot;98quot;%,IF(F3lt;7.72,quot;97quot; %,IF(F3lt;7.77,quot;96quot;%,IF(F3lt;8.1,quot;95quot;%,IF(F3lt;8.44,quot;94quot; %,IF(F3lt;8.96,quot;93quot;%,IF(F3lt;9.14,J3))))))))
gt;
gt; thanks,
gt; Mike
gt;
gt;
gt; --
gt; Michael L
gt; ------------------------------------------------------------------------
gt; Michael L's Profile: www.excelforum.com/member.php...oamp;userid=27787
gt; View this thread: www.excelforum.com/showthread...hreadid=538996
gt;
gt;