Good afternoon,

I currently have the following IF formula (provided by Dave total hero!)

=IF(B73="DL1 ",E73/$C$12,IF(B73="DV9 ",E73/$C$13,IF(B73="EA9 ",E73/$C$5,IF(B73="DX8 ",E73/$C$2,IF(B73="DZ5 ",E73/$C$3,IF(B73="EA8 ",E73/$C$4,IF(B73="EB0 ",E73/$C$6,IF(B73="EBG ",E73/$C$7,""))))))))

The problem is, I dont appear to be able to add anymore IF's without getting an error.

Is there a limit to the number of IFs I can put in and is there a way around it?