Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel can I make a letter value equal a specific number | Excel Discussion (Misc queries) | |||
how can i make a letter equal 1? | Excel Discussion (Misc queries) | |||
Making a letter equal 1 formula | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) |