Please help with formula

[Thysman68]

I'm buzy trying to redo my basline risk assessment . I'm fine to get at culom D, but strugeling with E. E must display for me VERY HIGH / HIGH / MEDIUM / LOW / VERY LOW. Can someone please help me

	A	B	C	D	E	F	G	H	I
1	CONSEQUENCE	EXPOSURE	PROBABILITY	RISK CALCULATION	RISK RATING		VERY HIGH	> 6000	=/< 8000
2	75	5	10	=(A2*B2*C2) =3750	?		HIGH	> 4000	=/< 6000
3	50	5	10	=(A3*B3*C3) =2500	?		MEDIUM	> 3000	=/< 4000
4	25	5	10	=(A4*B4*C4) =1250	?		LOW	> 2000	=/< 3000
5	100	5	10	=(A5*B5*C5) =5000	?		VERY LOW	> 0000	=/< 2000
6	100	7	10	=(A6*B6*C6) =7000	?
7
8
9

 

[jasonb75]

You need a different set up on the reference table for it to work.

Book1
	A	B	C	D	E	F	G	H
1	CONSEQUENCE	EXPOSURE	PROBABILITY	RISK CALCULATION	RISK RATING		VERY LOW	0
2	75	5	10	3750	MEDIUM		LOW	2001
3	50	5	10	2500	LOW		MEDIUM	3001
4	25	5	10	1250	VERY LOW		HIGH	4001
5	100	5	10	5000	HIGH		VERY HIGH	6001
6	100	7	10	7000	VERY HIGH
Sheet1

Cell Formulas
Range	Formula
D2:D6	D2	=PRODUCT(A2:C2)
E2:E6	E2	=LOOKUP(D2,$H$1:$H$5,$G$1:$G$5)

 

[Thysman68]

Buffelsjags Risk Assessment -2021.xlsx
	A	B	C	D	E	F	G	H	I	J	K																	AB	AC	AD
1	HAZARD IDENTIFICATION RISK ASSESSMENT
2	ASSESSMENT DONE WITH NO CONTROL MEASURES IN PLACE
3	HAZARD NUMBER	ACTIVITY	HAZARD	RISK	POPILATION	INITIAL RISK
4						CONSEQUENCE	EXPOSURE	PROBABILITY	RISK CALCULATION	RISK RATING
5	RA-001	BAD WEATHER CONDITIONS
6	RA-001-01		WIND - SAND AND DUST	EYE INJURIES	VISITERS, CONTRACTORS AND EMPLOYEES	25	10	5	1250
7	RA-001-02		RAIN	SICKNES (FLU) / SLIDE AND FALL	VISITERS, CONTRACTORS AND EMPLOYEES
8	RA-001-03		SUN - HEATWAVE	OVER HEATING / BURNING	VISITERS, CONTRACTORS AND EMPLOYEES
9	RA-002	ANIMAL BITES / STINGS
10	RA-002-01		POISONOUS SNAKE BITES	CAN LEAD TO SERIOS SICKNESS / FATALITY	VISITERS, CONTRACTORS AND EMPLOYEES
11	RA-002-02		POISONOUS SPIDER BITES	CAN LEAD TO SERIOS SICKNESS / FATALITY	VISITERS, CONTRACTORS AND EMPLOYEES
12	RA-002-03		POISONOUS SCORPION STINGS	CAN LEAD TO SERIOS SICKNESS / FATALITY	VISITERS, CONTRACTORS AND EMPLOYEES
13	RA-002-04		HONEY BEES	CAN LEAD TO SERIOS SICKNESS / FATALITY	VISITERS, CONTRACTORS AND EMPLOYEES
14																												Initial/Raw Risk Rating
15																												VERY HIGH	>6000	</=8000
16																												HIGH	>4000	</=6000
17																												MEDIUM	>3000	</=4000
18																												LOW	>2000	</=3000
19																												VERY LOW	>0000	</=2000
DCA

Cell Formulas
Range	Formula
I6	I6	=PRODUCT(F6:H6)

 

[jasonb75]

Do you have a follow up question / query? A new mini sheet without any accompanying information is not much of a clue.

 

[Thysman68]

Yes, please. I can't get your formula to work.

 

[Sanjeev1976]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1	HAZARD IDENTIFICATION RISK ASSESSMENT
2	ASSESSMENT DONE WITH NO CONTROL MEASURES IN PLACE
3	HAZARD NUMBER	ACTIVITY	HAZARD	RISK	POPILATION	INITIAL RISK
4						CONSEQUENCE	EXPOSURE	PROBABILITY	RISK CALCULATION	RISK RATING
5	RA-001	BAD WEATHER CONDITIONS
6	RA-001-01		WIND - SAND AND DUST	EYE INJURIES	VISITERS, CONTRACTORS AND EMPLOYEES	25	10	5	1250	VERY LOW
7	RA-001-02		RAIN	SICKNES (FLU) / SLIDE AND FALL	VISITERS, CONTRACTORS AND EMPLOYEES
8	RA-001-03		SUN - HEATWAVE	OVER HEATING / BURNING	VISITERS, CONTRACTORS AND EMPLOYEES
9	RA-002	ANIMAL BITES / STINGS
10	RA-002-01		POISONOUS SNAKE BITES	CAN LEAD TO SERIOS SICKNESS / FATALITY	VISITERS, CONTRACTORS AND EMPLOYEES
11	RA-002-02		POISONOUS SPIDER BITES	CAN LEAD TO SERIOS SICKNESS / FATALITY	VISITERS, CONTRACTORS AND EMPLOYEES
12	RA-002-03		POISONOUS SCORPION STINGS	CAN LEAD TO SERIOS SICKNESS / FATALITY	VISITERS, CONTRACTORS AND EMPLOYEES
13	RA-002-04		HONEY BEES	CAN LEAD TO SERIOS SICKNESS / FATALITY	VISITERS, CONTRACTORS AND EMPLOYEES
14																												Initial/Raw Risk Rating
15																												VERY HIGH	>6000	</=8000
16																												HIGH	>4000	</=6000
17																												MEDIUM	>3000	</=4000
18																												LOW	>2000	</=3000
19																												VERY LOW	>0000	</=2000
20
21																												VERY LOW	0
22																												LOW	2001
23																												MEDIUM	3001
24																												HIGH	4001
25																												VERY HIGH	6001
Sheet1

Cell Formulas
Range	Formula
I6	I6	=PRODUCT(F6:H6)
J6	J6	=LOOKUP(I6,$AC$21:$AC$25,$AB$21:$AB$25)
AB21	AB21	=AB19
AB22	AB22	=AB18
AB23	AB23	=AB17
AB24	AB24	=AB16
AB25	AB25	=AB15

This is what Jason meant

 

[jasonb75]

You need to add the reference table as shown in the mini sheet that I posted with the lowest at the top and the minimum score for each risk rating as a number only, no >= or < symbols (as @Sanjeev1976 has shown above).

 

[Thysman68]

THANKS A LOT GUYS