Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help me with an If statement
I am wanting to an if statement that evaluates whether the 1st cell in
a selected column is an integer. If it is I want to do nothing, if it isn't i want to insert a value in the cell to the left. Then I would like to move on to the next cell in the coloumn and evaluate as above. The only problem may be that when the cell is not an integer it will be either an; integer then a space then a letter or and integer then a letter (no space) Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help me with an If statement
Sub ifallnum() For Each c In Range("f2:f22") If Len(c) 0 And IsNumeric(c) Then c.Offset(, -1) = 33 Next End Sub Don Guillett SalesAid Software "keri" wrote in message oups.com... I am wanting to an if statement that evaluates whether the 1st cell in a selected column is an integer. If it is I want to do nothing, if it isn't i want to insert a value in the cell to the left. Then I would like to move on to the next cell in the coloumn and evaluate as above. The only problem may be that when the cell is not an integer it will be either an; integer then a space then a letter or and integer then a letter (no space) Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help me with an If statement
If your selected column is B, then in A1 insert the formula
=IF(ISNUMBER(B1),IF(B1=INT(B1),"","insert value"),"insert value") Replace "insert value" by whatever you want writing into that cell. Copy down. -- David Biddulph "keri" wrote in message oups.com... I am wanting to an if statement that evaluates whether the 1st cell in a selected column is an integer. If it is I want to do nothing, if it isn't i want to insert a value in the cell to the left. Then I would like to move on to the next cell in the coloumn and evaluate as above. The only problem may be that when the cell is not an integer it will be either an; integer then a space then a letter or and integer then a letter (no space) Thanks in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help me with an If statement
Don Guillett wrote: Sub ifallnum() For Each c In Range("f2:f22") If Len(c) 0 And IsNumeric(c) Then c.Offset(, -1) = 33 Next Thanks. I'm guessing (with my small knowledge) this is supposed to put 33 into the column to the right of the selected cell if it IS an integer. Is this correct? It's not working so far but i'll figure that out, problem is I need to do it if it is NOT an integer. Can i do a "is not"? Oh and what is len? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help me with an If statement
For NOT a number just insert NOT in front of isnumeric. Your original
request was for the column to the LEFT. If you want it to the right change -1 to 1. Also, I did this for a range of cells in col F. If you want for only one cell just change to if activecell, etc Len may be looked up in the vba help index -- Don Guillett SalesAid Software "keri" wrote in message ups.com... Don Guillett wrote: Sub ifallnum() For Each c In Range("f2:f22") If Len(c) 0 And IsNumeric(c) Then c.Offset(, -1) = 33 Next Thanks. I'm guessing (with my small knowledge) this is supposed to put 33 into the column to the right of the selected cell if it IS an integer. Is this correct? It's not working so far but i'll figure that out, problem is I need to do it if it is NOT an integer. Can i do a "is not"? Oh and what is len? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help me with an If statement
Thank you.
Don Guillett wrote: For NOT a number just insert NOT in front of isnumeric. Your original request was for the column to the LEFT. If you want it to the right change -1 to 1. Also, I did this for a range of cells in col F. If you want for only one cell just change to if activecell, etc Len may be looked up in the vba help index -- Don Guillett SalesAid Software "keri" wrote in message ups.com... Don Guillett wrote: Sub ifallnum() For Each c In Range("f2:f22") If Len(c) 0 And IsNumeric(c) Then c.Offset(, -1) = 33 Next Thanks. I'm guessing (with my small knowledge) this is supposed to put 33 into the column to the right of the selected cell if it IS an integer. Is this correct? It's not working so far but i'll figure that out, problem is I need to do it if it is NOT an integer. Can i do a "is not"? Oh and what is len? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
IF Statement problem | New Users to Excel | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |