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
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies