=IF((SUMIF(K25,"<0",K25))then(K25+P22+P21))*orIF(( SUMIF(K25,"0",K25))then(K25-(P22+P21)))

i am familiar with VBA a little... i understand the "or if" command is not in excel i just put it in so you guys could understand what i am trying to accomplish.