Help with an if statement
 

I am having trouble getting this to work. I want it to go something like
this "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. Basically I want these 2 if statements into one
cell.


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

"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

thanks I'm getting closer


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