a letter equal to a number

Hello out there

Working on a schedule for my teachers:
1 means the student attended the lesson and will get paid
A means the teacher cancelled the lesson and the teacher will not get paid

The number multiplices a certean number (in this case 25 min X 1), A does
nothing
This works, But!
S should mean that the student was ill, and couldnīt come, but the teacher
gets paid anyway!
M should mean that the student didnīt show up without any message given and
the teacher gets paid anyway!

So who do I get 1 to be equal with S and M...?


All the best
--
Grenaa Music School
Denmark

=or(A1=1,A1="M",A1="S")*25

if for a single column

=SUM(COUNTIF(A:A,{1,"M","S"})*25)

--
Regards,
Tom Ogilvy




"Grenaa Music school" <[email protected]> wrote in
message news:[email protected]...
> Hello out there
>
> Working on a schedule for my teachers:
> 1 means the student attended the lesson and will get paid
> A means the teacher cancelled the lesson and the teacher will not get paid
>
> The number multiplices a certean number (in this case 25 min X 1), A does
> nothing
> This works, But!
> S should mean that the student was ill, and couldnīt come, but the teacher
> gets paid anyway!
> M should mean that the student didnīt show up without any message given
and
> the teacher gets paid anyway!
>
> So who do I get 1 to be equal with S and M...?
>
>
> All the best
> --
> Grenaa Music School
> Denmark

Hi

This one worked for one cell:
=OR(A1="E";A1="s";A1=1)*25
I would like it to work for A1:Q1
ex:
The student schedule
tuesday (A1): 1
Wendesday(B1): s
Thursday(C1): m
= 75 min.

Etc...

Regards
Grenaa Music School
--
Grenaa Music School
Denmark


"Tom Ogilvy" skrev:

> =or(A1=1,A1="M",A1="S")*25
>
> if for a single column
>
> =SUM(COUNTIF(A:A,{1,"M","S"})*25)
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
> "Grenaa Music school" <[email protected]> wrote in
> message news:[email protected]...
> > Hello out there
> >
> > Working on a schedule for my teachers:
> > 1 means the student attended the lesson and will get paid
> > A means the teacher cancelled the lesson and the teacher will not get paid
> >
> > The number multiplices a certean number (in this case 25 min X 1), A does
> > nothing
> > This works, But!
> > S should mean that the student was ill, and couldnÂīt come, but the teacher
> > gets paid anyway!
> > M should mean that the student didnÂīt show up without any message given
> and
> > the teacher gets paid anyway!
> >
> > So who do I get 1 to be equal with S and M...?
> >
> >
> > All the best
> > --
> > Grenaa Music School
> > Denmark
>
>
>