Forum Discussion
hlt1322
Mar 18, 2022Copper Contributor
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...
HansVogelaar
Mar 18, 2022MVP
According to your description, U=5 and D=0, but your example uses U=0 and D=5. What gives?