I saw where you can have up to 64 nested formulas. I only have 15 and am getting an error. I'm pretty sure I did it correctly. Formula as follows:
=IF(C1="Abbott","2.75",IF(C1="Calabrio","2.75",IF(C1="Cellcom Repair","2.75",IF(C1="Cellcom Retail","2.75",IF(C1="Cellcom Service","2.75",IF(C1="Marvin","2.75",IF(C1="NCSS","2.75,IF(C1="USAA","2.75",IF(C1="Banking","3.00",IF(C1="Cellcom PO","3.00",IF(C1="Centra","3.00",IF(C1="HD Supply","3.00",IF(C1="HDS Order","3.00",IF(C1="CS PO","3.50",IF(C1="Ryder","4.00")))))))))))))))
I'm using Excel 2010. Any reason this isn't working? Thanks for any help!
=IF(C1="Abbott","2.75",IF(C1="Calabrio","2.75",IF(C1="Cellcom Repair","2.75",IF(C1="Cellcom Retail","2.75",IF(C1="Cellcom Service","2.75",IF(C1="Marvin","2.75",IF(C1="NCSS","2.75,IF(C1="USAA","2.75",IF(C1="Banking","3.00",IF(C1="Cellcom PO","3.00",IF(C1="Centra","3.00",IF(C1="HD Supply","3.00",IF(C1="HDS Order","3.00",IF(C1="CS PO","3.50",IF(C1="Ryder","4.00")))))))))))))))
I'm using Excel 2010. Any reason this isn't working? Thanks for any help!