Extended IF Formula
 

I use this formula to return the value in cell if the criteria is met but I would like to extend this to say that the value is also returned if cell J89 = ("C") i.e. either or I89 = W or J89 = C.

=IF(AND(A890,I89="w"),A89,"0")

Hope that makes sense

Extended IF Formula
 

If I understand, try this...

=IF(AND(A890,OR(I89="W",J89="C")),A89,0)

It can also be written as:

=AND(A890,OR(I89="W",J89="C"))*A89

--
Biff
Microsoft Excel MVP


"Barny" wrote in message
...

I use this formula to return the value in cell if the criteria is met
but I would like to extend this to say that the value is also returned
if cell J89 = ("C") i.e. either or I89 = W or J89 = C.

=IF(AND(A890,I89="w"),A89,"0")

Hope that makes sense




--
Barny

Extended IF Formula
 

"Barny" wrote:
I would like to extend this to say that the value
is also returned if cell J89 = ("C") i.e. either
or I89 = W or J89 = C.
=IF(AND(A890,I89="w"),A89,"0")

=IF(AND(A890,OR(I89="w",J89="c")), A89, 0)

Note that I wrote zero, not "0". That assumes that A89 is numeric, and you
want to return the number zero, not the text string "0".

PS: My formula above can be shortened to:

=A9*(A890)*(I89="w",J89="c")

If A9 cannot be less than zero, that can be simplified further to:

=A9*OR(I89="w",J89="c")


----- original message -----


"Barny" wrote in message
...

I use this formula to return the value in cell if the criteria is met
but I would like to extend this to say that the value is also returned
if cell J89 = ("C") i.e. either or I89 = W or J89 = C.

=IF(AND(A890,I89="w"),A89,"0")

Hope that makes sense




--
Barny

Extended IF Formula
 

=IF(AND(A890,OR(I89="w",J89="C")),A89,"0")

"Barny" wrote:


I use this formula to return the value in cell if the criteria is met
but I would like to extend this to say that the value is also returned
if cell J89 = ("C") i.e. either or I89 = W or J89 = C.

=IF(AND(A890,I89="w"),A89,"0")

Hope that makes sense




--
Barny
.

These formulas are fine and do the job, but what I would also now like to say is:

If I89= W return W in A89 or if J89 =C return C in A89
This is based on I89 / J89 either being blank or containing W or C
There will not be a scenario where I89 and J89 contain w and c at the same time