| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Function Argument Question
I'm having a brain freeze and cannot come up with the formula to express the
following: If A1 is greater than 0 but less than 3, return 50, If A1 is greater than 3 but less than 6, return 100, If A1 is great than 6, return 200. I was looking for a "between" function like in formatting, but I don't think that is how it's done. Thanks in advance for any help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function Argument Question
Hi War,
Try this: =if(A1=6,200,if(A13,200,50)) -- Hope this helps "WAR" wrote: I'm having a brain freeze and cannot come up with the formula to express the following: If A1 is greater than 0 but less than 3, return 50, If A1 is greater than 3 but less than 6, return 100, If A1 is great than 6, return 200. I was looking for a "between" function like in formatting, but I don't think that is how it's done. Thanks in advance for any help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function Argument Question
Thanks, Judith!
I think you typed in an error though, should it say "A1="? I took out the "=" and it worked. Wayne "JudithJubilee" wrote: Hi War, Try this: =if(A1=6,200,if(A13,200,50)) -- Hope this helps "WAR" wrote: I'm having a brain freeze and cannot come up with the formula to express the following: If A1 is greater than 0 but less than 3, return 50, If A1 is greater than 3 but less than 6, return 100, If A1 is great than 6, return 200. I was looking for a "between" function like in formatting, but I don't think that is how it's done. Thanks in advance for any help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function Argument Question
Hi. Just to mention...
If A1 is greater than 0 but less than 3, return 50, A1 of zero, or -2 also return 50. A1 <=0 was not specified. Just thought I'd mention it. :) = = = = = = HTH :) Dana DeLouis On 4/26/10 12:46 PM, WAR wrote: Thanks, Judith! I think you typed in an error though, should it say "A1="? I took out the "=" and it worked. Wayne "JudithJubilee" wrote: Hi War, Try this: =if(A1=6,200,if(A13,200,50)) -- Hope this helps "WAR" wrote: I'm having a brain freeze and cannot come up with the formula to express the following: If A1 is greater than 0 but less than 3, return 50, If A1 is greater than 3 but less than 6, return 100, If A1 is great than 6, return 200. I was looking for a "between" function like in formatting, but I don't think that is how it's done. Thanks in advance for any help! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Function Argument Question
You did not specify what to do if the answer was exactly 6. Less than 6 =
100. Greater than 6 = 200. Judith did not make a mistake. -- HTH... Jim Thomlinson "WAR" wrote: Thanks, Judith! I think you typed in an error though, should it say "A1="? I took out the "=" and it worked. Wayne "JudithJubilee" wrote: Hi War, Try this: =if(A1=6,200,if(A13,200,50)) -- Hope this helps "WAR" wrote: I'm having a brain freeze and cannot come up with the formula to express the following: If A1 is greater than 0 but less than 3, return 50, If A1 is greater than 3 but less than 6, return 100, If A1 is great than 6, return 200. I was looking for a "between" function like in formatting, but I don't think that is how it's done. Thanks in advance for any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Function 2nd argument | Excel Worksheet Functions | |||
| How can I get around 30 argument limit of SUM function? | Excel Worksheet Functions | |||
| Need Function Argument | Excel Worksheet Functions | |||
| text as an argument of SUM function | Excel Worksheet Functions | |||
| How do I specify more than one argument for the SUMIF function? | Excel Worksheet Functions | |||
Linear Mode
