| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need help with a function application with multiple arguments
if a is less than 4500 then b, if a is greater than or equal to 4500 but less
than 7500 then c, if a is greater or equal to 7500 then c |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
i need help with a function application with multiple arguments
"tarabull" wrote: if a is less than 4500 then b, if a is greater than or equal to 4500 but less than 7500 then c, if a is greater or equal to 7500 then c on the last "c" i meant "d" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
i need help with a function application with multiple arguments
On Fri, 2 Nov 2007 20:08:00 -0700, tarabull
wrote: if a is less than 4500 then b, if a is greater than or equal to 4500 but less than 7500 then c, if a is greater or equal to 7500 then c With "a" in A1: =VLOOKUP(A1,{-9.9999E+307,"b";4500,"c";7500,"d"},2) --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
i need help with a function application with multiple arguments
One way:
=IF(a<4500,b,IF(a<7500,c,d)) In article , tarabull wrote: if a is less than 4500 then b, if a is greater than or equal to 4500 but less than 7500 then c, if a is greater or equal to 7500 then c |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Arguments | Excel Discussion (Misc queries) | |||
| sum with multiple arguments | Excel Worksheet Functions | |||
| Multiple Arguments | Excel Worksheet Functions | |||
| how do I count with multiple arguments | Excel Worksheet Functions | |||
| Multiple vlookup arguments | Excel Worksheet Functions | |||
Linear Mode
