lrobbo314
Well-known Member
- Joined
- Jul 14, 2008
- Messages
- 3,963
- Office Version
- 365
- Platform
- Windows
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
)
)
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") |
Upvote
1