Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
I am making a chart for children and they get a certian amount of money for
each smiley face they get. I want to know how to make a smiley face equal a certian amount of money so it is easy to add up at the end of the row. if you dont understand what I am asking please let me know because I would like an answer asap. Thanks!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
=TEXT(COUNTIF(A2:F2,"J")*0.25,"$0.00")
The upper case J in Wingding font is the smiley face......... The 0.25 represents 25 cents per smily face...... The A2:F2 is the assemed range of your cells......... hth Vaya con Dios, Chuck, CABGx3 "bigstar326" wrote: I am making a chart for children and they get a certian amount of money for each smiley face they get. I want to know how to make a smiley face equal a certian amount of money so it is easy to add up at the end of the row. if you dont understand what I am asking please let me know because I would like an answer asap. Thanks!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
will this work if i am using other things besides smiley faces other than
just J in wingding? "CLR" wrote: =TEXT(COUNTIF(A2:F2,"J")*0.25,"$0.00") The upper case J in Wingding font is the smiley face......... The 0.25 represents 25 cents per smily face...... The A2:F2 is the assemed range of your cells......... hth Vaya con Dios, Chuck, CABGx3 "bigstar326" wrote: I am making a chart for children and they get a certian amount of money for each smiley face they get. I want to know how to make a smiley face equal a certian amount of money so it is easy to add up at the end of the row. if you dont understand what I am asking please let me know because I would like an answer asap. Thanks!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
Thanks for the feedback.........
Yes, it should work for any character, any font. Vaya con Dios, Chuck, CABGx3 "bigstar326" wrote: will this work if i am using other things besides smiley faces other than just J in wingding? "CLR" wrote: =TEXT(COUNTIF(A2:F2,"J")*0.25,"$0.00") The upper case J in Wingding font is the smiley face......... The 0.25 represents 25 cents per smily face...... The A2:F2 is the assemed range of your cells......... hth Vaya con Dios, Chuck, CABGx3 "bigstar326" wrote: I am making a chart for children and they get a certian amount of money for each smiley face they get. I want to know how to make a smiley face equal a certian amount of money so it is easy to add up at the end of the row. if you dont understand what I am asking please let me know because I would like an answer asap. Thanks!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
how do i get it to work if i want to use more than one letter at a time?
"bigstar326" wrote: will this work if i am using other things besides smiley faces other than just J in wingding? "CLR" wrote: =TEXT(COUNTIF(A2:F2,"J")*0.25,"$0.00") The upper case J in Wingding font is the smiley face......... The 0.25 represents 25 cents per smily face...... The A2:F2 is the assemed range of your cells......... hth Vaya con Dios, Chuck, CABGx3 "bigstar326" wrote: I am making a chart for children and they get a certian amount of money for each smiley face they get. I want to know how to make a smiley face equal a certian amount of money so it is easy to add up at the end of the row. if you dont understand what I am asking please let me know because I would like an answer asap. Thanks!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
=TEXT(COUNTIF(A2:F2,"Chuck")*0.25,"$0.00")
Vaya con Dios, Chuck, CABGx3 "bigstar326" wrote: how do i get it to work if i want to use more than one letter at a time? "bigstar326" wrote: will this work if i am using other things besides smiley faces other than just J in wingding? "CLR" wrote: =TEXT(COUNTIF(A2:F2,"J")*0.25,"$0.00") The upper case J in Wingding font is the smiley face......... The 0.25 represents 25 cents per smily face...... The A2:F2 is the assemed range of your cells......... hth Vaya con Dios, Chuck, CABGx3 "bigstar326" wrote: I am making a chart for children and they get a certian amount of money for each smiley face they get. I want to know how to make a smiley face equal a certian amount of money so it is easy to add up at the end of the row. if you dont understand what I am asking please let me know because I would like an answer asap. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|