Heart Rate Zones

[CrashMatRob]

Hi All,
I am trying to do a formula based on heart rate zones during exercise.
So far all I have is below:

=IF(AND(A1>50,A1<60),"Very Light","False")
This would be in cell B2.

B2 would result “Very Light” if cell A1 was between 50 – 60 or result “False” if not.

Would it be possible to incorporate the following in to Formula?

Cell A1 Cell B2
50-60 “Very Light”
60-70 “Light”
70-80 “Moderate”
80-90 “Hard”
90-100 “Very Hard”

Any help would be appreciated.

 

[Fluff]

How about

=IFERROR(CHOOSE(INT(A2/10)-4,"Very Light","Light","Moderate","Hard","Very Hard"),"False")

 

[EXCEL MAX]

HelloCrashMAtRob,
maybe something like this...

[/RANGE]

Cell Formulas
Range	Formula
B2	B2	=IF(AND(A1>50,A1<60),"Very Light",IF(AND(A1>60,A1<70),"Light",IF(AND(A1>70,A1<80),"Moderate",IF(AND(A1>80,A1<90),"Hard",IF(AND(A1>90,A1<100),"Very Hard","False")))))

 

[Dave Patton]

Try a Lookup with or without a Table.
N.B. numbers like 60 cannot be both the top of one range and the bottom of the next.
The formula that I posted leaves 60 in the lower category.
Try the option that you prefer.

T202101a.xlsm
	A	B	C	D	E
1	105	Very Hard		Rate	Description
2				0	Caution
3	60	Very Light		50	Very Light
4				60.001	Light
5	105	Very Hard		70.001	Moderate
6				80.001	Hard
7				90.001	Very Hard
2a

Cell Formulas
Range	Formula
B1,B3	B1	=LOOKUP(A1,$D$2:$E$7)
B5	B5	=LOOKUP(A5,{0,"Caution";50,"Very Light";60.001,"Light";70.001,"Moderate";80.001,"Hard";90.001,"Very Hard"})

 

[CrashMatRob]

How about

=IFERROR(CHOOSE(INT(A2/10)-4,"Very Light","Light","Moderate","Hard","Very Hard"),"False")

This would work for me,
Thank you.

 

[CrashMatRob]

Thank you all,
I have found "Fluff"'s result will work for me.

Regards
Rob.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Dave Patton]

T202101a.xlsm
	A	B	C	D	E
1	105	Very Hard +		Rate	Description
2	60	Light		0	Caution
3				50	Very Light
4				60	Light
5				70	Moderate
6				80	Hard
7				90	Very Hard
8				100	Very Hard +
2a

Cell Formulas
Range	Formula
B1	B1	=LOOKUP(A1,$D$2:$E$8)
B2	B2	=LOOKUP(A2,D2:D8,E2:E8)