| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
range in an IF statement
I need the IF statement to look for numbers 1100 through 1199, then put 11 in
another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
would this work?
=left(a2,2) -- Don Guillett SalesAid Software "Dorothy J" wrote in message ... I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
Is this what you were trying to do?
=IF(AND(A1=1100,A1<1200),11,"") -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Dorothy J" wrote: I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
I put that in but it made no difference, I used my own figures, correct?
-- Dorothy J "Don Guillett" wrote: would this work? =left(a2,2) -- Don Guillett SalesAid Software "Dorothy J" wrote in message ... I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
=IF(AND(A1=1100,A1<=1199),11,"")
or =IF(A1/100=11,11,"") or if the number is not an integer =IF(INT(A1/100)=11,11,"") or if you can live with zero when the value is not in the range =11*(INT(A1/100)=11) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dorothy J" wrote in message ... I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
sort of, but you gave me an idea....
-- Dorothy J "John Bundy" wrote: Is this what you were trying to do? =IF(AND(A1=1100,A1<1200),11,"") -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Dorothy J" wrote: I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
Your answer made it work, putting in the sign worked. I didn't need the
AND though...I think!! THANKS!!!! -- Dorothy J "John Bundy" wrote: Is this what you were trying to do? =IF(AND(A1=1100,A1<1200),11,"") -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Dorothy J" wrote: I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
maybe try this
=11*--and(a1=1100,a1<1200) -- ***** birds of the same feather flock together.. "Dorothy J" wrote: I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
THANKS!
-- Dorothy J "dribler2" wrote: maybe try this =11*--and(a1=1100,a1<1200) -- ***** birds of the same feather flock together.. "Dorothy J" wrote: I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range in an IF statement
your welcome
-- ***** birds of the same feather flock together.. "Dorothy J" wrote: THANKS! -- Dorothy J "dribler2" wrote: maybe try this =11*--and(a1=1100,a1<1200) -- ***** birds of the same feather flock together.. "Dorothy J" wrote: I need the IF statement to look for numbers 1100 through 1199, then put 11 in another cell. How do I get the IF statement to recognize the range 1100 through 1199? Meaning, any number between 1100 and 1199 should be given the number 11? -- Dorothy J |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement (non nested) that compares cell value against range | Excel Worksheet Functions | |||
| Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
| Using a worksheet name from a range | Excel Worksheet Functions | |||
| How do I use a range of numbers in an if statement? | Excel Worksheet Functions | |||
| If statement where the logical test is a range that equals a word | Excel Worksheet Functions | |||
Linear Mode
