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
|