Extended IF Formula
T. Valko;939697 Wrote:
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 -
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
--
Barny
|