# Nested if >7

Posted by Bob on April 12, 2001 10:20 AM

Kenny, Looks like this will work!

=IF(A50<=5,(IF(A50=1,C50/SUMIF(A:A,"=1",C:C),IF(A50=2,C50/SUMIF(A:A,"=2",C:C),IF(A50=3,C50/SUMIF(A:A,"=3",C:C),IF(A50=4,C50/SUMIF(A:A,"=4",C:C),IF(A50=5,C50/SUMIF(A:A,"=5",C:C))))))),IF(A50>=6,(IF(A50=6,C50/SUMIF(A:A,"=6",C:C),IF(A50=7,C50/SUMIF(A:A,"=7",C:C),IF(A50=8,C50/SUMIF(A:A,"=8",C:C)))))))