software

I am trying to rank salespeople unit sales and I am getting an error I can
not figure out. This is the formula I am using =RANK(C15,Leases) where the
whole column of figures is names leases. Some cells rank fine but some do
not. The cells that seem to not calculate right are decimal numbers like 1.5
or 6.5. Anyone who can help me would be greatly appreciated.

Amy,

There may not be an exact comparison on the numbers you are looking up.
e.g., 1.55 instead of 1.5
--
HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758quot;Amyquot; wrote:

gt; I am trying to rank salespeople unit sales and I am getting an error I can
gt; not figure out. This is the formula I am using =RANK(C15,Leases) where the
gt; whole column of figures is names leases. Some cells rank fine but some do
gt; not. The cells that seem to not calculate right are decimal numbers like 1.5
gt; or 6.5. Anyone who can help me would be greatly appreciated.

Unfortunately, that did not help. the only thing that makes the formula work
is to change it to a whole number which is not true. if this formula will not
work for this purpose is there another formula I can insert instead?

quot;galimiquot; wrote:

gt; Amy,
gt;
gt; There may not be an exact comparison on the numbers you are looking up.
gt; e.g., 1.55 instead of 1.5
gt; --
gt; HelpExcel.com
gt; 1-888-INGENIO
gt; 1-888-464-3646
gt; x0197758
gt;
gt;
gt; quot;Amyquot; wrote:
gt;
gt; gt; I am trying to rank salespeople unit sales and I am getting an error I can
gt; gt; not figure out. This is the formula I am using =RANK(C15,Leases) where the
gt; gt; whole column of figures is names leases. Some cells rank fine but some do
gt; gt; not. The cells that seem to not calculate right are decimal numbers like 1.5
gt; gt; or 6.5. Anyone who can help me would be greatly appreciated.