In Excel can I make a letter value equal a specific number

[JDSkiing]

For example, If I wanted every time the letter F was input as data that,
within the fields marked that F would equal the number one, then for example
G would equal 1.5, so that if a row had three F's and 2 G's it would equal 6
if I totalled the row across. This is a simple xample of what I am trying to
accomplish, but if someone can show me this I can figure out the rest.
Thank you
James Deutschkron

 

[Gary''s Student]

Say the row is B1 thru Z1. In A1 enter:

 

[Gary''s Student]

Say the data is in A1 thru Z1, In A1 enter:

=COUNTIF(B1:Z1,"F")+COUNTIF(B1:Z1,"G")*1.5

 

[JDSkiing]

Thank you for the response, am I also able to use more than one letter for
example would =COUNTIF(B1:Z1,"F")+COUNTIF(B1:Z1,"FF")*1.5, also work if FF is
equal to 1.5, and can I copy this formula down among multiple rows

 

[Gary''s Student]

Yes.

There nice thing about this approach is that you can extend it to cover a
lot more codes.