I am trying to calculate a number in a "total" cell, but some of the cells
I'm using in the calculation contain $0.00, "NA", "Included", "TBD". I asked
this question before and got an excellent response, but then I only had the
words "included". 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="included",0,D5)*4)+if(B55="included",0 ,B55).

I need to modify this so it will work if what's in the "included" 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="included",d5="NA",d5="TBD"),0,d5)*4 )+if(or(b55="included",b55="NA",b55="TBD"),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!1
:)

Regards

Carl


HR Wrote:
I am trying to calculate a number in a "total" cell, but some of the
cells
I'm using in the calculation contain $0.00, "NA", "Included", "TBD". I
asked
this question before and got an excellent response, but then I only had
the
words "included". 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="included",0,D5)*4)+if(B55="included",0 ,B55).

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

Can anyone help me with this!?


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=541313

Thank 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.

"HR" wrote:

I am trying to calculate a number in a "total" cell, but some of the cells
I'm using in the calculation contain $0.00, "NA", "Included", "TBD". I asked
this question before and got an excellent response, but then I only had the
words "included". 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="included",0,D5)*4)+if(B55="included",0 ,B55).

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

Can anyone help me with this!?