"if e10 e9 then equal the total e11+f30 and if f30the total of e9-e10
then equal the total of f30-e11 if both of those statements are false
egual 0

=if(e10e9,e11+f30,if(f30e9-e10,f30-e11,0))


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=375499