Help Need writing a formula Please [Solved/Closed]

Report
-
 6Sigma -
Hello,
I have a report I pull which outputs IDs. There are 5 IDs. Management would like to display their respective Site locations instead of the IDs.

IDS: RICTFH --- Greenville
RICS7X -- Findlay
RICJOK --- Marion
RIC2N7 --- Clyde
P959DO --- Benton Harbor

Basically, I assume I need to write an IF statement to display the given site if an ID value =x?
I attempted several w/ only errors. I'm a novice w/ formulas.

Any input is highly appreciated.
Thanks Much

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You needed nested if

generally if is like

=IF(COND, true action, false action)

your need to have if with if and so on


=IF(COND1, true, IF(COND2, true, IF(COND3, true, false)))

like

=IF(a1="RICTFH", "Greenville", IF(a1="RICS7X", "Findlay,...

By the way, you can have upto 7 nested if
Wow - Thanks for the education rizvisa1...Much Appreciated.
Works like a charm!! :)
Cheers

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!