Need a ranking value in a column to top out at 7. Even though there are 15 numbers in the

Hello,

Looking for assistance with a value rating of ranked numbers in a column.

Book 2 attached.

I have in this case 10 numbers in a column B (can be as high as 15)

54
46
68
48
59
64
34
42
58
67

In column C I have this formula to rank the values: =IF(B1="","",(RANK(B1,$B$1:$B$15)))

so now it looks like this ...

54 -- 06
46 -- 08
68 -- 01
48 -- 07
59 -- 04
64 -- 03
34 -- 10
42 -- 09
58 -- 05
67 -- 02

I am looking at allowing a maximum value in column C to be 7.

What formula would I use to make this happen?

Thank you for your help with this issue,
Leonard

=if(b1="","",min(rank(b1,$b$1:$b$15),7))