Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement
Hi there,
I have a workbook that gives me information with time in 24hr clock and what l alo have is a list of of numbers that l want to match as close as possibleo each time. example list of numbers to choose from 06:00 230 07;00 231 08:00 232 So what l am trying to do is if 06;00 equals 230 then put in 230 into column whatever then 07:00 would have to equal 231 then 08;00 would have to be 232 and so on it will always equal a number referenced of the side numbers so there will be no false statement. what l have done is =if(f:f<300,"230"),(g:g) l want it to put the information back into column G. So what l am trying to say is if <300 make it 230 and return it to column G. then for the next one l have done is =if(f:f0700,"231"),(g:g) if greater than 0700 make it 231. Can l do this at all as l have value written in column G? Thanks chris -- chris |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement
Are your values in the first column (and the values with which you are
comparing them) Excel times, or text values, or a mixture? In your message you've got a mixture of formats such as 06;00 and 06:00. Excel times should be 06:00. If you want to compare with 06:00 you can either use TIME(6,0,0) or --"06:00". Your syntax for the IF function is wrong. Look in Excel help at the syntax. Remember also that a formula won't return a value for a column, but a value for a cell. You can then copy that formula to other cells in the column if you so wish. You may also need to be more careful with your comparison formulae, as to whether you want < or <=, and similarly or =. Think about what you want the formula to give if the values aree equal. -- David Biddulph "hotlh" wrote in message ... Hi there, I have a workbook that gives me information with time in 24hr clock and what l alo have is a list of of numbers that l want to match as close as possibleo each time. example list of numbers to choose from 06:00 230 07;00 231 08:00 232 So what l am trying to do is if 06;00 equals 230 then put in 230 into column whatever then 07:00 would have to equal 231 then 08;00 would have to be 232 and so on it will always equal a number referenced of the side numbers so there will be no false statement. what l have done is =if(f:f<300,"230"),(g:g) l want it to put the information back into column G. So what l am trying to say is if <300 make it 230 and return it to column G. then for the next one l have done is =if(f:f0700,"231"),(g:g) if greater than 0700 make it 231. Can l do this at all as l have value written in column G? Thanks chris -- chris |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if statement
Here is a suggestion
=INDEX(B:B,ROUNDUP(A1*24,0)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "hotlh" wrote in message ... Hi there, I have a workbook that gives me information with time in 24hr clock and what l alo have is a list of of numbers that l want to match as close as possibleo each time. example list of numbers to choose from 06:00 230 07;00 231 08:00 232 So what l am trying to do is if 06;00 equals 230 then put in 230 into column whatever then 07:00 would have to equal 231 then 08;00 would have to be 232 and so on it will always equal a number referenced of the side numbers so there will be no false statement. what l have done is =if(f:f<300,"230"),(g:g) l want it to put the information back into column G. So what l am trying to say is if <300 make it 230 and return it to column G. then for the next one l have done is =if(f:f0700,"231"),(g:g) if greater than 0700 make it 231. Can l do this at all as l have value written in column G? Thanks chris -- chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
if statement | Excel Discussion (Misc queries) | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |