If Statement looking at more than one sequence
 

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?

If Statement looking at more than one sequence
 

yes can be done

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

--
Greetings from New Zealand
Bill K
"heater" wrote in message
...
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?