These three function can do the same job pretty well. We use a combination of IF AND (Nested IF Function), the new IFS and VLOOKUP function to look up for commission percentages on a table array to calculate the commissions based on sales in another table.
#AFunctionADay #VLOOKUP #LogicalFunctions
Download Class File Below
https://www.opencastlabs.co.ke/how-to...