Help with an if statement

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.
 
D

duane

"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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incone & Expenses Statement 0
Payment calculation 1
using an IF or AND function to get next largest value in list 1
if then statements 6
Formula 6
Page numbering with Merged Document and IF statements 1
ABS <= and logic functions 5
dividing 0 by 0 in excel 2003 10

Top