Help with an if statement

  • Thread starter Thread starter Crew
  • Start date Start date
C

Crew

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 f30>the 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.
 
"if e10 > e9 then equal the total e11+f30 and if f30>the total of e9-e10
then equal the total of f30-e11 if both of those statements are false
egual 0

=if(e10>e9,e11+f30,if(f30>e9-e10,f30-e11,0))
 
Back
Top