Subnet Id

[kjacw]

Hello all
I need help with finding the closest number to a cell reference. I am familiar with using macros and written a few, but I'm at a loss on this one.
I am trying to find the closet number to my cell refenece O2 which is 77, I have a range to look in F3:F11. The number it finds will always be smaller larger than cell reference O2 but not larger. For example it will be between 64 and 96 but the number to be selected and stored in a variable is 64.
Thanks, I hope that helps. I am using Excel 2013 on Win 10 64bit.

 

[Fluff]

How about

Int(Range("O2") / 32) * 32

 

[kjacw]

How about

Int(Range("O2") / 32) * 32

I'm sorry Fluff, Yes that one worked what you gave me but here is what i'm after.
1. My search number is O2,
2. Subnet Column is N2 (If my subnet falls within one of these subnets, the search needs to take place in this column). Another variable will supply this info

So it all depends on which subnet N2 and my search number O2, then the result will then be stored into a variable and used accordingly.

Sorry for the confusion or lack of other info. I have uploaded the pics below. I just don't know how to write code to say find my search number, ex 119 in the 32 Subnet column and tell me what number is it close to.

Thanks for the quick reply

 

[Fluff]

Not quite sure what you are after but perhaps

   Dim a As Long, b As Long
   a = Range("N2").Value
   b = Int(Range("O2") / a) * a