hey i need to know how to make a letter(checkmark) appear as a dollar amount when going into a total
S stacy Feb 27, 2007 #1 hey i need to know how to make a letter(checkmark) appear as a dollar amount when going into a total
L Lauren Giles Feb 27, 2007 #2 What? That doesn't make much sense... If I understand you correctly, just format the cell as currency or accounting, noting the dollar sign.
What? That doesn't make much sense... If I understand you correctly, just format the cell as currency or accounting, noting the dollar sign.
B Bernie Deitrick Feb 27, 2007 #3 Stacy, Array enter (enter using Ctrl-Shift-Enter) a formula like =SUM(EXACT(A1:A1000,B1)*AMOUNT) where B1 contains a checkmark (format it with the same font), and AMOUNT has been replace with the value of each checkmark.... HTH, Bernie MS Excel MVP
Stacy, Array enter (enter using Ctrl-Shift-Enter) a formula like =SUM(EXACT(A1:A1000,B1)*AMOUNT) where B1 contains a checkmark (format it with the same font), and AMOUNT has been replace with the value of each checkmark.... HTH, Bernie MS Excel MVP
