I am looking for a solution to the following scenario.
IF Cell A1 = "W" & Cell C5 = "X" & Cell F13 = "Y" is TRUE then return the value of Cell H26 but
IF Cell A1 = "W" & Cell C5 = "Y" & Cell F13 = "X" is TRUE then return the value of Cell Cell G56 but
If FALSE = 0
I have tried several combinations of IF, AND & / or OR and cannot find a solution. I either get messages that I have included too many arguments of the formula is incorrect.
I am sure the solution is simple.
Thanks in advance
IF Cell A1 = "W" & Cell C5 = "X" & Cell F13 = "Y" is TRUE then return the value of Cell H26 but
IF Cell A1 = "W" & Cell C5 = "Y" & Cell F13 = "X" is TRUE then return the value of Cell Cell G56 but
If FALSE = 0
I have tried several combinations of IF, AND & / or OR and cannot find a solution. I either get messages that I have included too many arguments of the formula is incorrect.
I am sure the solution is simple.
Thanks in advance