software

Someone helped me with this previously, and I accidentally cleared the
information (and the location of the post) from my computer. Ugh!

I'd appreciate help once again, and I promise not to lose it this time.

I need an If Then Else statement to combine the following:

If E gt; 0, then H2-E2
If E2=0 and F2=0, then H2-D2

THANKS!

=IF(E2gt;0,H2-E2,IF(AND(E2=0,F2=0),H2-D2),quot;quot;)

What about

E2 = 0, F2 lt;gt; 0
E2 lt;0?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;wrosiequot; gt; wrote in message
...
gt; Someone helped me with this previously, and I accidentally cleared the
gt; information (and the location of the post) from my computer. Ugh!
gt;
gt; I'd appreciate help once again, and I promise not to lose it this time.
gt;
gt; I need an If Then Else statement to combine the following:
gt;
gt; If E gt; 0, then H2-E2
gt; If E2=0 and F2=0, then H2-D2
gt;
gt; THANKS!
Thanks...we're almost there! When I input your formula, it tells me there are
too many arguments for this function. If I use it without the final set ofd
quotation marks, it inserts FALSE in the cells where F2 has a value. I need
it to be blank any time F has a value.

quot;Bob Phillipsquot; wrote:

gt; =IF(E2gt;0,H2-E2,IF(AND(E2=0,F2=0),H2-D2),quot;quot;)
gt;
gt; What about
gt;
gt; E2 = 0, F2 lt;gt; 0
gt; E2 lt;0?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;wrosiequot; gt; wrote in message
gt; ...
gt; gt; Someone helped me with this previously, and I accidentally cleared the
gt; gt; information (and the location of the post) from my computer. Ugh!
gt; gt;
gt; gt; I'd appreciate help once again, and I promise not to lose it this time.
gt; gt;
gt; gt; I need an If Then Else statement to combine the following:
gt; gt;
gt; gt; If E gt; 0, then H2-E2
gt; gt; If E2=0 and F2=0, then H2-D2
gt; gt;
gt; gt; THANKS!
gt;
gt;
gt;

Bracket in wrong place

=IF(E2gt;0,H2-E2,IF(AND(E2=0,F2=0),H2-D2,quot;quot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;wrosiequot; gt; wrote in message
...
gt; Thanks...we're almost there! When I input your formula, it tells me there
are
gt; too many arguments for this function. If I use it without the final set
ofd
gt; quotation marks, it inserts FALSE in the cells where F2 has a value. I
need
gt; it to be blank any time F has a value.
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; =IF(E2gt;0,H2-E2,IF(AND(E2=0,F2=0),H2-D2),quot;quot;)
gt; gt;
gt; gt; What about
gt; gt;
gt; gt; E2 = 0, F2 lt;gt; 0
gt; gt; E2 lt;0?
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;wrosiequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Someone helped me with this previously, and I accidentally cleared the
gt; gt; gt; information (and the location of the post) from my computer. Ugh!
gt; gt; gt;
gt; gt; gt; I'd appreciate help once again, and I promise not to lose it this
time.
gt; gt; gt;
gt; gt; gt; I need an If Then Else statement to combine the following:
gt; gt; gt;
gt; gt; gt; If E gt; 0, then H2-E2
gt; gt; gt; If E2=0 and F2=0, then H2-D2
gt; gt; gt;
gt; gt; gt; THANKS!
gt; gt;
gt; gt;
gt; gt;
Perfect! MANY thanks!

quot;Bob Phillipsquot; wrote:

gt; Bracket in wrong place
gt;
gt; =IF(E2gt;0,H2-E2,IF(AND(E2=0,F2=0),H2-D2,quot;quot;))
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;wrosiequot; gt; wrote in message
gt; ...
gt; gt; Thanks...we're almost there! When I input your formula, it tells me there
gt; are
gt; gt; too many arguments for this function. If I use it without the final set
gt; ofd
gt; gt; quotation marks, it inserts FALSE in the cells where F2 has a value. I
gt; need
gt; gt; it to be blank any time F has a value.
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; =IF(E2gt;0,H2-E2,IF(AND(E2=0,F2=0),H2-D2),quot;quot;)
gt; gt; gt;
gt; gt; gt; What about
gt; gt; gt;
gt; gt; gt; E2 = 0, F2 lt;gt; 0
gt; gt; gt; E2 lt;0?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;wrosiequot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Someone helped me with this previously, and I accidentally cleared the
gt; gt; gt; gt; information (and the location of the post) from my computer. Ugh!
gt; gt; gt; gt;
gt; gt; gt; gt; I'd appreciate help once again, and I promise not to lose it this
gt; time.
gt; gt; gt; gt;
gt; gt; gt; gt; I need an If Then Else statement to combine the following:
gt; gt; gt; gt;
gt; gt; gt; gt; If E gt; 0, then H2-E2
gt; gt; gt; gt; If E2=0 and F2=0, then H2-D2
gt; gt; gt; gt;
gt; gt; gt; gt; THANKS!
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;