If... and... or checking multiple columns

I have an employee timesheet on a worksheet. Each day is split into two columns (AM and PM).
Column A has employee names

Column B is the first day (e.g. Monday) AM shift
Column C is the PM shift
Each AM or PM shift could be represented by the following inputs which are conditionally formatted.

S Sick

AL Annual Leave

** (Any other input means shift worked)

(no input means shift not worked/day off/do not count etc.

Column D requires a function to check for Sick input "S" in either B or C, returning 1 if both columns are "S", 0.5 if one of the columns is "S" or 0 if neither column has "S"
Column E requires a function to check for Annual Leave input "AL" again showing as 1, 0.5 or 0
Column F requires a function to check for any other input, again showing as 1, 0.5 or 0

If column D has a value of 1, columns E and F cannot have a value at all and so forth...
If column D has a value of 0.5, columns E and F can only have a maximum value of 0.5...
The value of D, E and F has to be a maximum of 1.

I need three functions to handle the input options. I think each function has to handle either "S"; "AL"; "**" and "".

Any help would be much appreciated.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

You have given us a completely empty table:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D	E	F
1		Monday	11-Jul
2		AM	PM	Sick	Leave	Worked
3	John
4	Mary

Sheet: Sheet1

I asked for this:

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Hi - have uploaded a replacement workbook to #1. I have some limited experience with 'If And' and 'If Or' functions but nesting multiple scenarios as I would require here is proving beyond my ability.
Thank you for your help.

The following yield the results that are shown in the workbook attached to post #1:
For D3 and down: =COUNTIFS(B3:C3,"s")*0.5
For E3 and down: =COUNTIFS(B3:C3,"al")*0.5
For F3 and down: =COUNTIFS(B3:C3,"<>",B3:C3,"<>S",B3:C3,"<>al")*0.5
Let us know if you have any questions.