Re: Combine Multiple If Formulas
please help me with this fomula, the first part of the IF...=IF('Fin Hse'!I57<='Fin Hse'!CU57,0.4*I5...works, the second part works...IF(AND('Fin Hse'!I57>'Fin Hse'!CU57,'Fin Hse'!I57<='Fin Hse'!CU57+5),0.5*Score!I5... but the third part ...IF(AND('Fin Hse'!I57>'Fin Hse'!CU57+5,'Fin Hse'!I57<='Fin Hse'!CU57+10),0.7*Score!I5,0))) does not work, i expect it to retun 21 i.e 0.7*Score!I5 but it woes not work, please help.
=IF('Fin Hse'!I57<='Fin Hse'!CU57,0.4*I5,IF(AND('Fin Hse'!I57>'Fin Hse'!CU57,'Fin Hse'!I57<='Fin Hse'!CU57+5),0.5*Score!I5,IF(AND('Fin Hse'!I57>'Fin Hse'!CU57+5,'Fin Hse'!I57<='Fin Hse'!CU57+10),0.7*Score!I5,0)))