I am trying to combine the below formulas into one formula. I have already tested each one to make sure they work independently. I keep getting an error when I try to combine them.

Any help is appreciated.


=IF(E2=Quartiles!$E$2,IF('2010-2019 Compiled'!I2>=Quartiles!E$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!E$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!E$3,"Short"))))

=IF(E2=Quartiles!$F$2,IF('2010-2019 Compiled'!I2>=Quartiles!F$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!F$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!F$3,"Short"))))

=IF(E2=Quartiles!$G$2,IF('2010-2019 Compiled'!I2>=Quartiles!G$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!G$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!G$3,"Short"))))

=IF(E2=Quartiles!$H$2,IF('2010-2019 Compiled'!I2>=Quartiles!H$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!H$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!H$3,"Short"))))

=IF(E2=Quartiles!$I$2,IF('2010-2019 Compiled'!I2>=Quartiles!I$6,"Tall",IF('2010-2019 Compiled'!I2>=Quartiles!I$4,"Average",IF('2010-2019 Compiled'!I2>=Quartiles!I$3,"Short"))))