Function Math Miscellaneous Class

FrequencyToBandNumber

Return the band number for a frequency measured in Hertz (cycles per second).

Signature (Visual Basic / VBA)

Public Function FrequencyToBandNumber( _
    ByVal vFreqInHz As Variant _
    ) As Variant

Code Examples

    FrequencyToBandNumber(980000) = 6
    FrequencyToBandNumber(575000000) = 9
    FrequencyToBandNumber(10000000) = 7
    FrequencyToBandNumber(123) = 2
    FrequencyToBandNumber(-123) = -1
    Int(LogNReal(Frequency, 10) - LogNReal(3, 10) + 1)

Parameters

Parameter Description
vFreqInHz Number representing a frequency as measured in Hertz or cycles per second. Function returns Null if vFreqInHz is Null or cannot be fixed up to a number. Function returns -1 if vFreqInHz is <= 0 (less than or equal to zero).