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! |
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 |