Forum Discussion
If functions
Looking for a formula that can say 'if A plus B happens take action X, but if A and C instead happens then take action Y'. Is that possible in Excel?
Hi Riny
A and B are not values nor blank. I'm basically trying to say that if two particular criteria are met (A and B) then the required action should be X. Neither the criteria nor the action is numeric values.
Example:
Blue + Yellow is Green, but Blue + Red is purple.
A and B are not values nor blank. I'm basically trying to say that if two particular criteria are met (A and B) then the required action should be X. Neither the criteria nor the action is numeric values.
Example:
Blue + Yellow is Green, but Blue + Red is purple.
IF(AND(A=TRUE,B=TRUE), DoThisAction, DoThatAction)
IF(AND(A=5,B=5), x*y, x-y)
IF(AND(A=5,B=5), x*y, x-y)