software

I am trying to calculate a number in a quot;totalquot; cell, but some of the cells
I'm using in the calculation contain $0.00, quot;NAquot;, quot;Includedquot;, quot;TBDquot;. I asked
this question before and got an excellent response, but then I only had the
words quot;includedquot;. I can't seem to manipulate the formula to work when a row
has more than one word (NA, Included, TBD).

Here's what I'm using:
=sum(if(D5=quot;includedquot;,0,D5)*4) if(B55=quot;includedquot;,0 ,B55).

I need to modify this so it will work if what's in the quot;includedquot; part is
included, NA, or TBD.

Can anyone help me with this!?


Hi,
Not an expert in these matters but I think I had a similar problem to
yourself and solved it using this formula

=sum(if(or(d5=quot;includedquot;,d5=quot;NAquot;,d5=quot;TBDquot;),0,d5)*4 ) if(or(b55=quot;includedquot;,b55=quot;NAquot;,b55=quot;TBDquot;),0,B55)

You can add as many words as you like within the OR pattern, just keep
on following the same design.

Hope that is of some help - or at least not messed you up even more!1Regards

CarlHR Wrote:
gt; I am trying to calculate a number in a quot;totalquot; cell, but some of the
gt; cells
gt; I'm using in the calculation contain $0.00, quot;NAquot;, quot;Includedquot;, quot;TBDquot;. I
gt; asked
gt; this question before and got an excellent response, but then I only had
gt; the
gt; words quot;includedquot;. I can't seem to manipulate the formula to work when
gt; a row
gt; has more than one word (NA, Included, TBD).
gt;
gt; Here's what I'm using:
gt; =sum(if(D5=quot;includedquot;,0,D5)*4) if(B55=quot;includedquot;,0 ,B55).
gt;
gt; I need to modify this so it will work if what's in the quot;includedquot; part
gt; is
gt; included, NA, or TBD.
gt;
gt; Can anyone help me with this!?--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: www.excelforum.com/member.php...oamp;userid=34352
View this thread: www.excelforum.com/showthread...hreadid=541313Thank you so much! That worked! These formulas are so picky - I tried this
a number of ways, but didn't include the (or( after the IF! Thanks again.

quot;HRquot; wrote:

gt; I am trying to calculate a number in a quot;totalquot; cell, but some of the cells
gt; I'm using in the calculation contain $0.00, quot;NAquot;, quot;Includedquot;, quot;TBDquot;. I asked
gt; this question before and got an excellent response, but then I only had the
gt; words quot;includedquot;. I can't seem to manipulate the formula to work when a row
gt; has more than one word (NA, Included, TBD).
gt;
gt; Here's what I'm using:
gt; =sum(if(D5=quot;includedquot;,0,D5)*4) if(B55=quot;includedquot;,0 ,B55).
gt;
gt; I need to modify this so it will work if what's in the quot;includedquot; part is
gt; included, NA, or TBD.
gt;
gt; Can anyone help me with this!?