Total rows w/$, NA, Included
 

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!?

Total rows w/$, NA, Included
 

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

Total rows w/$, NA, Included
 

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!?