Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need a formula like this "@if(2000
I look for some one help me in develop this formula for excel.
=IF(Sheet2!D8<2000,(Sheet2!D10),IF(2000<Sheet2!E8< 17000,(Sheet2!E10),IF(17000<Sheet2!F8<30000,(Sheet 2!F10),IF(30000<Sheet2!G8<50000,(Sheet2!G10),IF(Sh eet2!H850000,(Sheet2!H10),(0)))))) |
#2
|
|||
|
|||
Hi
i think this will work =IF(Sheet2!D8<2000,Sheet2!D1,IF(AND(Sheet2!E82000 ,Sheet2!E8<17000),Sheet2!E10,IF(AND(Sheet2!F81700 0,Sheet2!F8<30000),Sheet2!F10,IF(AND(Sheet2!G8300 00,Sheet2!G8<50000),Sheet2!G10,IF(Sheet2!H850000, Sheet2!H10,0))))) Cheers JulieD "jlperezlafuente" wrote in message ... I look for some one help me in develop this formula for excel. =IF(Sheet2!D8<2000,(Sheet2!D10),IF(2000<Sheet2!E8 <17000,(Sheet2!E10),IF(17000<Sheet2!F8<30000,(Shee t2!F10),IF(30000<Sheet2!G8<50000,(Sheet2!G10),IF(S heet2!H850000,(Sheet2!H10),(0)))))) |
#3
|
|||
|
|||
Take a look in the help file at the VLOOKUP(), HLOOKUP(), & LOOKUP()
functions. One or more of them will do exactly what you want. "jlperezlafuente" wrote: I look for some one help me in develop this formula for excel. =IF(Sheet2!D8<2000,(Sheet2!D10),IF(2000<Sheet2!E8< 17000,(Sheet2!E10),IF(17000<Sheet2!F8<30000,(Sheet 2!F10),IF(30000<Sheet2!G8<50000,(Sheet2!G10),IF(Sh eet2!H850000,(Sheet2!H10),(0)))))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions |