LinkBack URL
About LinkBacks
Hello All,
I am writing an IF formula in excel but want to create an outcome subject to two conditions.
I want it to work like this.
=IF(CELLX="A" & CELLY="B" THEN "OUTCOME Z" IF NOT THEN "BLANK")
Thanks in advance
Hello All,
I am writing an IF formula in excel but want to create an outcome subject to two conditions.
I want it to work like this.
=IF(CELLX="A" & CELLY="B" THEN "OUTCOME Z" IF NOT THEN "BLANK")
Thanks in advance
Try
=IF(AND(Cellx="A",CellY="B"),OutcomeZ,"")
Brilliant thanks for that!
cheers. please take the time to mark the thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks