Thread: Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bigstar326 bigstar326 is offline
external usenet poster
 
Posts: 3
Default 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!!