G
Guest
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))))))
=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))))))