Forum Discussion
Tarig Elsawi
Sep 08, 2023Copper Contributor
If conditional multiplication
Hi, i have a table containing exchange rate and I would like excel to multiply cells based on currency symbol on each cell. for example, if the cell is £150 then excel should lookup £ exchange from...
- Sep 09, 2023
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
PeterBartholomew1
Sep 09, 2023Silver Contributor
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
Sep 11, 2023I understand this was a known issue that's been fixed. Please let us know otherwise.
- PeterBartholomew1Sep 12, 2023Silver Contributor
Yes. All is good now, thanks.