The user needed a formula to "give a result of 3-4 years, 5-6 years, 7-8 years based on a score that is given" where the a raw score of 9-14 gives 3-4 years, 15-19 gives 5-6 years, etc.
The user's formula simply said "IF(B3 greater_than_or_equal_to 9, "3-4 years")."
Here I look at the original formula along with several alternative: a chain of IF() functions, the IFS() function, and SWITCH(); then a lookup table with VLOOKUP() and XLOOKUP().
I prefer and suggest using the lookup table with either VLOOKUP() or XLOOKUP(). They are much more clear, operate in a single function, and the options can be easily adjusted in the table.
Music courtesy of CORTEXX
open.spotify.com/artist/4fOVG4v2qJ38qUbzA4KTY2
#googlesheets #googlesheetstutorial #googlesheetstips #googlesheetsguide
https://www.facebook.com/profile.php?id=61571458064705&sk=reels_tab
https://x.com/SpencersSheets
https://bsky.app/profile/spencerssheets.bsky.social
https://www.instagram.com/spencerteachessheets/reels/
I use Bandicam to record, Clipchamp to edit, and a Blue Yeti microphone
Donate on Paypal: [email protected]
