If statement returns false instead of value

[seiyakou]

Hello all,

Really new to doing anything complicated in excel, so if this formula is a complete mess I apologize. This makes sense to me, but instead of returning a value it just gives me False. Any help is appreciated. Thanks!

Please Login or Register  to view this content.

[Ace_XL]

Use this..

=IF($H$8=Worksheet!$E$2,IF(ISBLANK(I23),(H37-I28-I29),IF(ISTEXT(I23),(H37-I21-I22-I23-I28-I29),"")),"")