Home

Which formula to use to report different values for multiple logical tests

ucypcwe
Occasional Visitor

Hi, I am not sure what formula(s) to use for the following: I would like to test whether a value in a cell (call the value N) falls within different ranges, and report a different value depending on the range within which N falls. For example, IF(1<N<9.99) report "A", OR IF(10<N<19.99) report "B", OR IF(20<N<29.99) report "C", (report "FALSE" if none of the above conditions met). I can do separate IF formulae in multiple columns but is there a way to combine multiple tests into a single formula string? Thanks.

1 Reply
You may use this formula:
=LOOKUP(N,
{1,10,20,30},
{“A”,”B”,”C”,”FALSE”})
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies