Function in excel 2013 [Solved/Closed]

Report
-
Posts
11549
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
July 14, 2020
-
Hello Dear All.
who I can do this function in excel 2013

If A2=AB return value from A1 cell , if A2 = CD return from A3 cell value


1 reply

Posts
11549
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
July 14, 2020
4
Perhaps this?
=IF(A2="AB";A1;IF(A2="CD";A3;"?"))