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