PDA

View Full Version : Excel Questions on using "Switch" formula



mhall
02-20-2019, 10:22 AM
I am currently learning how to use some of excel advanced functions. However, I recently discovered that excel has a switch function and I was wondering if anyone has used this function and can give me an idea when this function would be helpful. Thank you.

Paul_Hossler
03-23-2019, 06:18 PM
I moved your post to the Excel forum

Don't know if you're still interested, but here's an example. Notice that SWITCH uses inputs in pairs


23943