I need an Excel genius

[tommyturner]

Hi

This is probably very simple for you experts out there but I'm stuck!

In one cell I will have a number, if under 1300 I want the cell beside it to say LOW, if over 1300 but under 1800 I want it to say MEDIUM and if over 1800 I want it to say HIGH. Sometimes it will be blank so if I can avoid any error warnings when that happens it would be ideal.

If you can give me the relevant IF formula (I believe) it would be most appreciated!

Thanks

TT

 

[Jonmo1]

Welcome to the board..

Will the number ever be negative?
If Not, try

=LOOKUP(A1,{0,1300,1800},{"LOW","MEDIUM","HIGH"})

Blanks will be considered 0, therefore Less than 1300, therefore resulting in LOW.


Hope that helps.

 

[VoG]

Try

=IF(A1="","",LOOKUP(A1,{0,1301,1801},"LOW","MEDIUM","HIGH"}))

 

[p45cal]

Excel Workbook
	K	L
9	1299	LOW
10	1300	MEDIUM
11	1799	MEDIUM
12	1800	HIGH
13	1801	HIGH
14	g	-o-
15		-o-
Sheet1

L9 copied down, but you don't define what you want if the value is exactly 1300 or exactly 1800.

 

[tommyturner]

Guys thank you very much! I'm amazed at the speed of response!

Jonmo1, that worked well so thank you!

VoG, it came back that I had too many arguements, but thanks for your help.

p45cal - that also worked really well as zeros are discounted so I'll go with that solution! Many thanks.

Thanks for your help everyone - problem solved!

Tom

 

[snoopyhr]

just another approach ...

Excel Workbook
	I	J
7	1300	Low
hls

 

[T. Valko]

Hi

This is probably very simple for you experts out there but I'm stuck!

In one cell I will have a number, if under 1300 I want the cell beside it to say LOW, if over 1300 but under 1800 I want it to say MEDIUM and if over 1800 I want it to say HIGH. Sometimes it will be blank so if I can avoid any error warnings when that happens it would be ideal.

If you can give me the relevant IF formula (I believe) it would be most appreciated!

Thanks

TT

Your levels are not well defined:

under 1300
over 1300
under 1800
over 1800

What if the value IS 1300 or 1800?

Are negative numbers possible? Is 0 a valid entry?