If Statement looking at more than one sequence

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following formula =IF((E76+H76)>5000000,((E76+H76)-500000,"")) -
which does not work and needs another sequence added to it. I need the
formula to look at E76 + H76 and if those two numbers are greater than
5,000,000 then add E76 + H76 and subtract 500,000. Also, I need it to look
at E76 + H76 and if those two numbers are less than 5,000,000 then add E76 +
H76 and multiply that answer by 90%. Can this be done?
 
yes can be done

=IF((E76+H76)=0,"",IF((E76+H76)>=5000000,(E76+H76)-500000,(E76+H76)*0.9))
 

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

IF statement problem 3
If Statement with 9 sequences 1
if then this statements 1
how do I write a formula if b2 is less than a2 then subtract 3
HELP!! New to Excel. Need complex SUMIF. 0
IF Statement not working 7
Formula Greater than Less Than 4
If statement with 9 sequences.. problem 9

Back
Top