If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

FREQCONV

lrobbo314 · 2023-01-28T17:21:01+00:00

FREQCONV converts a frequency e.g. mhz to ghz =LAMBDA(value,from,to, LET( lbl,{"hz";"khz";"mhz";"ghz"}, m,1000^SEQUENCE(4,,0), fx,LAMBDA(x,XLOOKUP(x,lbl,m,0)), fv,fx(from), tv,fx(to), (fv/tv)*value ) ) JK130.000350.00035J13J13=LAMBDA(value,from,to,LET(lbl,{"hz";"khz";"mhz";"ghz"},m,1000^SEQUENCE(4,,0),fx,LAMBDA(x,XLOOKUP(x,lbl,m,0)),fv,fx(from),tv,fx(to),(fv/tv)*value))(350,"hz","mhz")K13K13=FREQCONV(350,"hz","mhz")

Thread starter lrobbo314
Start date Jan 28, 2023

=FREQCONV(double,string,string)

value: value to convert

from: frequency string

to: frequency string

Convert a frequency e.g. mhz to ghz

lrobbo314

Well-known Member

Jan 28, 2023

FREQCONV converts a frequency e.g. mhz to ghz

Excel Formula:

=LAMBDA(value,from,to,
    LET(
        lbl,{"hz";"khz";"mhz";"ghz"},
        m,1000^SEQUENCE(4,,0),
        fx,LAMBDA(x,XLOOKUP(x,lbl,m,0)),
        fv,fx(from),
        tv,fx(to),
            (fv/tv)*value
    )
)

FREQ FUNCS.xlsm

0.00035

Sheet1

Cell Formulas
Range	Formula
J13	J13	=LAMBDA(value,from,to,LET(lbl,{"hz";"khz";"mhz";"ghz"},m,1000^SEQUENCE(4,,0),fx,LAMBDA(x,XLOOKUP(x,lbl,m,0)),fv,fx(from),tv,fx(to),(fv/tv)*value))(350,"hz","mhz")
K13	K13	=FREQCONV(350,"hz","mhz")