Little tricky question

[Nikky78]

Hi. I love your vid Glad to found it.

Ok, here it goes. I have little trickier question, that we didn't found an answer.

Here it goes: If I have to put in one cell formula like that... if the value of the cell is from 0 up to 100, than is 1, if the value of the cell is from 100 to 200, then is 2, if the value is from 300 to 400 is 4... like never ending value. In cell it just be seen nubmers 1 or 2 or 3 or 4... I hope that I wrote good enough to understand. If you need more data, please ask. It's Excel 2003.

 

[SteveO59L]

Try posting a sample of your data, and what you would like to do with it

 

[VoG]

Try

=CEILING(A1/100,1)

 

[Nikky78]

Ok, I'll do that when I come home in the afternoon.

 

[mgirvin]

Maybe this will help:

Data, notes and formulas (formulas in green):

Excel Workbook
	A	B	C	D	E	F	G	H
1	5	1				These are the categories for how the VLOOKUP works
2	125	2		0	1	0<= value< 100
3	215	3		100	2	100<= value< 200
4	22	1		200	3	200<= value< 300
5	0	1		300	4	value > 300
6	900	4
7	-1	#N/A		<< == Values less than the first value in the column 1 of the lookup table will get an #N/A
...

Formula in B1, and copy down:

Excel Workbook
	B
1	1
...

Cell Formulas
Range	Formula
B1	=VLOOKUP(A1,$D$2:$E$5,2)

 

[mgirvin]

Opps. The categories are like this (I left out an equal sign on the last category):<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

Excel Workbook
	D	E	F
1			These are the categories for how the VLOOKUP works
2	0	1	0<= value< 100
3	100	2	100<= value< 200
4	200	3	200<= value< 300
5	300	4	value >= 300
...

 

[Nikky78]

Ok, thank you. I'll try this. If won't work, I'll posted print screen of sheet. Thx.

 

[VoG]

Rather than a screenshot please use Excel Jeanie - we can copy from that and paste into Excel.

Link http://www.excel-jeanie-html.de/html/hlp_schnell_en.php