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

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:
Related Conversations