switch statement
is there a switch statement that i can use in a cell as a formula? i have a value in col a. in col e i want that if the value in a is 1, it should return the value in col B, if it's 2, return col C if it's 3, return col D. I know that i can do this with a nested if statement but i prefer switch - if someone can please tell me how to do this i would really appreciate it. Thank you. -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=386912 |
One way:
E1: =CHOOSE(A1,B1,C1,D1) In article , tkaplan wrote: is there a switch statement that i can use in a cell as a formula? i have a value in col a. in col e i want that if the value in a is 1, it should return the value in col B, if it's 2, return col C if it's 3, return col D. I know that i can do this with a nested if statement but i prefer switch - if someone can please tell me how to do this i would really appreciate it. Thank you. |
All times are GMT +1. The time now is 02:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com