Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if questions
Hello, i want to compare a cell between two number and return the sample
quantity. I tried to do this using the IF and & functions, but it dosent works beacuse i put more than 7 if. The table that i want to use is the following batch qty sample 2 8 2 9 15 3 16 25 5 26 50 8 51 90 13 91 150 20 151 280 32 281 500 50 501 1200 80 1201 3200 125 3201 10000 200 10001 35000 315 35001 150000 500 150001 500000 800 500001 more than 1250 IN other words, the function has to compare the value that i enter and compare with the batch qty range and return the sample qty, for example: If my current batch qty is 1220, the function has to return as sample qty 125 Thanks in advance Mauro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
007 questions | Charts and Charting in Excel | |||
Two little questions | Excel Discussion (Misc queries) | |||
2 questions | Excel Discussion (Misc queries) | |||
I have tow questions: | Excel Discussion (Misc queries) |