Help Need writing a formula Please

6Sigma - Mar 16, 2010 at 02:08 PM
 6Sigma - Mar 16, 2010 at 08:39 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 16, 2010 at 03:33 PM
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)))


=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!! :)