Forum Discussion
If conditional multiplication
Depending upon the situation, one possible solution is to write a named Lambda function
ExtractCurrencyFormatλ = LAMBDA(ref, LET( rawFormat, GET.CELL(7, ref), TEXTBEFORE(TEXTAFTER(rawFormat, "["), "]") ) )The worksheet formula would be
= ExtractCurrencyFormatλ(currencyAmount) for a single value, or = MAP(currencyAmount, ExtractCurrencyFormatλ) for an array.Reference:
How to find the currency format in a formula | MrExcel Message Board
Depending upon the situation, one possible solution is to write a named Lambda function
ExtractCurrencyFormatλ
= LAMBDA(ref,
LET(
rawFormat, GET.CELL(7, ref),
TEXTBEFORE(TEXTAFTER(rawFormat, "["), "]")
)
)The worksheet formula would be
= ExtractCurrencyFormatλ(currencyAmount)
for a single value, or
= MAP(currencyAmount, ExtractCurrencyFormatλ)
for an array.
Reference:
How to find the currency format in a formula | MrExcel Message Board
Hans, the board has suddenly decided that I should not be allowed to post pictures. Has any such thing happened to you or have I been singled out for demotion?
- cuong
Microsoft
I understand this was a known issue that's been fixed. Please let us know otherwise.Yes. All is good now, thanks.
It looks like it has to do with the new community ranks such as Silver Contributor - see What’s New in the MTC? September 2023 – Community Ranks
I hope that the powers that be will correct this soon.
It hasn't happened to me, but as MVP I (like SergeiBaklan) probably have a higher permissions level than you.
