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,(Sheet2!F10),IF(30000<Sheet2!G8<50000,(Sheet2!G10),IF(Sheet2!H8>50000,(Sheet2!H10),(0))))))
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,(Sheet2!F10),IF(30000<Sheet2!G8<50000,(Sheet2!G10),IF(Sheet2!H8>50000,(Sheet2!H10),(0))))))
Hi
i think this will work
=IF(Sheet2!D8<2000,Sheet2!D1,IF(AND(Sheet2!E8>2000,Sheet2!E8<17000),Sheet2!E10,IF(AND(Sheet2!F8>17000,Sheet2!F8<30000),Sheet2!F10,IF(AND(Sheet2!G8>30000,Sheet2!G8<50000),Sheet2!G10,IF(Sheet2!H8>50000,Sheet2!H10,0)))))
Cheers
JulieD
"jlperezlafuente" <[email protected]> wrote in
message news:[email protected]...
>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,(Sheet2!F10),IF(30000<Sheet2!G8<50000,(Sheet2!G10),IF(Sheet2!H8>50000,(Sheet2!H10),(0))))))
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,(Sheet2!F10),IF(30000<Sheet2!G8<50000,(Sheet2!G10),IF(Sheet2!H8>50000,(Sheet2!H10),(0))))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks