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
|