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 
Ads 
#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  

