jaelmelisse08 jaelmelisse08 04-05-2024 Computers and Technology Answered On the Compensation sheet, in cell H8, use nested IF functions to determine the bonus level. Use absolute references for the Bonus table and if they did not reach 100% return E8-100%.