Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
I need a formula for excel that will round down an odd number in a cell to
the next even number. I also need a formula example: if a number cell is =a number range (say, 1 to 1-1/2), the new cell should contain a message (such as:"A", "B", "BBC", etc) -- confused |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
For the first. I'm assuming that A1 is an integer here. If not, the
formula will need to change =IF(MOD(A1,2)=1,A1-1,A1) Have you defined what you want for the ranges Say 1 to 1 1/2 is aa 1 1/2 to 2 is bb 2 to 2 1/2 is cc If so, I'm thinking that VLOOKUP or LOOKUP will be helpful to you. Do a search on them and see if they would work. -- HTH, Barb Reinhardt "so confused" wrote: I need a formula for excel that will round down an odd number in a cell to the next even number. I also need a formula example: if a number cell is =a number range (say, 1 to 1-1/2), the new cell should contain a message (such as:"A", "B", "BBC", etc) -- confused |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
Do you know?
When i copy a cell A1 from file 1 with 500 words in it to file 2 in B2, after past I see only 35 words out of 500? "Barb Reinhardt" wrote: For the first. I'm assuming that A1 is an integer here. If not, the formula will need to change =IF(MOD(A1,2)=1,A1-1,A1) Have you defined what you want for the ranges Say 1 to 1 1/2 is aa 1 1/2 to 2 is bb 2 to 2 1/2 is cc If so, I'm thinking that VLOOKUP or LOOKUP will be helpful to you. Do a search on them and see if they would work. -- HTH, Barb Reinhardt "so confused" wrote: I need a formula for excel that will round down an odd number in a cell to the next even number. I also need a formula example: if a number cell is =a number range (say, 1 to 1-1/2), the new cell should contain a message (such as:"A", "B", "BBC", etc) -- confused |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
I suspect that none of us knew that. Is there a question here?
"Lookup formula limitation?" wrote: Do you know? When i copy a cell A1 from file 1 with 500 words in it to file 2 in B2, after past I see only 35 words out of 500? "Barb Reinhardt" wrote: For the first. I'm assuming that A1 is an integer here. If not, the formula will need to change =IF(MOD(A1,2)=1,A1-1,A1) Have you defined what you want for the ranges Say 1 to 1 1/2 is aa 1 1/2 to 2 is bb 2 to 2 1/2 is cc If so, I'm thinking that VLOOKUP or LOOKUP will be helpful to you. Do a search on them and see if they would work. -- HTH, Barb Reinhardt "so confused" wrote: I need a formula for excel that will round down an odd number in a cell to the next even number. I also need a formula example: if a number cell is =a number range (say, 1 to 1-1/2), the new cell should contain a message (such as:"A", "B", "BBC", etc) -- confused |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with formula
=FLOOR(A1,2)
-- David Biddulph "so confused" wrote in message ... I need a formula for excel that will round down an odd number in a cell to the next even number. .... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|