IFS function – Microsoft Support

Which says IF(the value in cell F2 equals 1, then return the value in cell D2, IF the value in cell F2 equals 2, then return the value in cell D3, and so on, finally ending with the value in cell D8 if none of the other conditions are met).. Remarks. To specify a default result, enter TRUE for your final logical_test argument. If none of the other conditions are met, the corresponding value …

https://support.microsoft.com/en-us/office/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45