I have 2 "IF" statements with 7 and 5 conditions, respectively. When these statements are in the cell singly, they give me the numerical result I'm expecting, which can be summed. However, when I add the IF statements together using "&" it results in the right answer, but in a text form which I cannot sum. Thanks in advance for any help on this matter.
=IF(T266="Airfield",I266,IF(U266="Landside Operations",I266*'Alloc Pct'!$C$7,IF(U266="Facilities Maintenance",I266*'Alloc Pct'!$C$8,IF(U266="Airport Security",I266*'Alloc Pct'!$C$9,IF(U266="Environmental Affairs",I266*'Alloc Pct'!$C$10,IF(U266="Airport Operations",I266*'Alloc Pct'!$C$11,IF(U266="Facilities Development",I266*'Alloc Pct'!$C$12,"")))))))&IF(U266="Real Estate Management",I266*'Alloc Pct'!$C$13,IF(U266="Airport Planning",I266*'Alloc Pct'!$C$14,IF(U266="Airport System Planning",I266*'Alloc Pct'!$C$15,IF(U266="G & A",I266*'Alloc Pct'!$C$16,""))))
Bookmarks