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

Help with Time in formula 2
if then statements 6
Conditional Function 1
Need a simple formula please 3
Help Please 6
dividing 0 by 0 in excel 2003 10
ABS <= and logic functions 5
help please 5

Top