If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 -- Barny |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 . |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|