Using IF with AND, OR, and NOT functions in Excel
WEBIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
IFS function - Microsoft Support
WEBThe IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
Detect errors in formulas - Microsoft Support
WEBThe following are some tools that you can use to find and investigate the causes of these errors and determine solutions. Note: This topic contains techniques that can help you correct formula errors. It's not an exhaustive list of …
SUM function - Microsoft Support
WEBHow to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.