Menu

Previous Topic Next Topic

Function in excel 2013 [Solved/Closed]

Report

Saber Elajam - Dec 24, 2016 at 01:59 AM
yg_be

Posts: 15976
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: June 10, 2021

- Dec 24, 2016 at 06:02 AM

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

Related:

Function in excel 2013
Search function vba excel - How-To - Excel
Print function in excel ✓ - Forum - Excel
How do i use an if function in excel for dates - How-To - Excel
How to change enter key function in excel - How-To - Excel
Maximum number of if functions in excel - How-To - Excel

1 reply

Answer 1 / 1

yg_be

Posts: 15976
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: June 10, 2021

5
Dec 24, 2016 at 06:02 AM

Perhaps this?

=IF(A2="AB";A1;IF(A2="CD";A3;"?"))

Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Recommended

DON'T MISS