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

a letter equal to a number
 

=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" wrote in
message ...
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

a letter equal to a number
 

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" wrote in
message ...
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