Help Need writing a formula PleaseSolved/Closed

Question

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

rizvisa1 · Answer

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

6Sigma · Answer

Wow - Thanks for the education rizvisa1...Much Appreciated.
Works like a charm!! :)
Cheers

Help Need writing a formula Please

2 responses

Similar discussions

Subscribe To Our Newsletter!