software

I have the following formula =IF((E76 H76)gt;5000000,((E76 H76)-500000,quot;quot;)) -
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,quot;quot;,IF((E76 H76)gt;=5000000,(E76 H76)-500000,(E76 H76)*0.9))

--
Greetings from New Zealand
Bill K
quot;heaterquot; gt; wrote in message
...
gt;I have the following formula =IF((E76 H76)gt;5000000,((E76 H76)-500000,quot;quot;)) -
gt; which does not work and needs another sequence added to it. I need the
gt; formula to look at E76 H76 and if those two numbers are greater than
gt; 5,000,000 then add E76 H76 and subtract 500,000. Also, I need it to
gt; look
gt; at E76 H76 and if those two numbers are less than 5,000,000 then add E76
gt;
gt; H76 and multiply that answer by 90%. Can this be done?