Forum Discussion
Converting a letter into a dollar amount
I am trying to set a excel document that will allow me to convert an X in a cell into a dollar amount in another cell. I would like to place an X in a cell in a column so that I don't have to keep t...
For this solution I'm presuming the data is not tabled:
=MMULT(N(Tally="X"),TOCOL(Amount))