Forum Discussion
excel formula problem
I need to create a formula that changes a letter price code into the corresponding price. The price code is CONSUMERAD=1234567890, c=1, o=2, n=3 and so on. I need the formula to have a $#,###.## fo...
If return as text like
it could be
=TEXT(
TEXTJOIN(,1,
MOD(
XMATCH( MID(B3, SEQUENCE(LEN(B3)), 1),
MID(B2, SEQUENCE(LEN(B2)), 1) ),
10 )
)/100,
"[$$-en-US]#,##0.00" )If as number - above without TEXT() and apply proper format.