💻 Software

Does Excel have anything like a 3-way switch?

Fresh6 days ago

Mar 15, 202619866 views

Confidence Score0%

Problem

In short, if one wanted to make an IF switch a) if A < 0.5 ... B = 10. b) if A >= 0.5 ... B = 15. c) if A > 1.0 ... B = 20. How would one go about that?

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Does Excel have anything like a 3-way switch?

Low Risk

You can nest "if" expressions like this: (I added A1<=1 otherwise because A>1.0 implies A also >= 0.5)

Awaiting Verification

Be the first to verify this fix

Does Excel have anything like a 3-way switch?

Problem

1 Fix

Fix for: Does Excel have anything like a 3-way switch?

Environment