When we are constructing a simple or complex formula LET function will be very handy, just imagine it works like a variable/parameter where you can declare your value or formula with a meaningful name and reuse it with the name within the formula construction each time required
XLOOKUP made the life easy to make the dependent dropdown list, we would have never imagined that it would be so simple to construct the formula. Check out post & get you sample file for free of download
IF function performs a logical test and return one value for a TRUE or FALSE result. For example, to “pass” scores must be above 35, So the constitution of the formula reads as below
