IF formula not working

[dougOrama]

Working on metadata for a music library. I'm having problems with an IF formula, there are five possible outcomes for the cell named "Tempo":
Unspecified
Very Fast (131+BPM)
Fast (111-130BPM)
Medium (90-110 BPM)
Slow (0-89 BPM)

In my formula, S2 is the BPM value of each song

=IF(S2<90,"Slow (0-90 BPM)",IF(S2>130,"Very Fast (131-130 BPM)",IF(AND(S2<111,S2>89), "MEDIUM (90-110 BPM)", IF(AND(S2<131,S2>110),"Fast (111-130 BPM)", "Unspecified”))))

I'm a a total newbie, thanks in advance for any help.

 

[Michael M]

Maybe this....but What defines "unspecified"

=IF(S2<90,"Slow (0-90 BPM))",IF(S2<111,"MEDIUM (90-110 BPM))",IF(S2<131,"Fast (111-130 BPM))",IF(S2>130,"Very Fast (131-130 BPM))"))))

 

[jtakw]

Hi,

A couple of ways:

Book1
	D	E	S
1	Fast (111-130 BPM)	Fast (111-130 BPM)
2			120
Sheet27

Cell Formulas
Range	Formula
D1	=IF(S2="","Unspecified",IF(S2>=131,"Very Fast (131+BPM)",IF(S2>=111,"Fast (111-130 BPM)",IF(S2>=90,"Medium (90-110 BPM)","Slow (0-89 BPM)"))))
E1	=IF(S2="","Unspecified",LOOKUP(S2,{0,90,111,131},{"Slow (0-89 BPM)","Medium (90-110 BPM)","Fast (111-130 BPM)","Very Fast (131+ BPM)"}))

 

[dougOrama]

Thanks so much! This is working except for "Unspecified" - the answer would be unspecified if there is no data there.

Maybe this....but What defines "unspecified"

=IF(S2<90,"Slow (0-90 BPM))",IF(S2<111,"MEDIUM (90-110 BPM))",IF(S2<131,"Fast (111-130 BPM))",IF(S2>130,"Very Fast (131-130 BPM))"))))

 

[jtakw]

Thanks so much! This is working except for "Unspecified" - the answer would be unspecified if there is no data there.

Then use one of my suggested formulae in Post #3

 

[dougOrama]

Perfect, the first one worked like a charm. Thank you kind wizard.

Then use one of my suggested formulae in Post #3

 

[jtakw]

You're welcome., welcome to the forum.