Trying to make a spreadsheet where a column of "codes" need to stand for a dollar amount. example: TS=$5.00 and TB=$10.00. I need it where I can set up cells later, where someone can enter TS, TS, TB and it will figure out the sum, which would be $20.00 (TS+TS+TB). I know how to do the sum part, but how do I format the cells so that like TS, which is in cell A1 stands for the dollar amount in B1??? So that later when someone puts TS in a cell, it looks at it as being $5, and not TS. helllllllllllllllllllllp!!!!
2007-09-19
14:03:11
·
4 answers
·
asked by
Jackson
2
in
Software